Search results for query: *

Blom, I have to build the datamart. It only contains 8 tables. It's an Informix datamart. I have the tables ready and have loaded with data. But how do I do the sizing estimate for the whole datamart. Is there some kind of calculation or do I have to analyze on how my data is growing? Thank you...

hello all, I have to allocate space for the datamart. But I am not sure how to. Any insight is really helpful. Thank you.

Hi All, I want to use mapping variable to do incremental load. The prob is my source doesn't have any date columns. I tried putting sessstarttime as loadtime and used a lookup to look for the sessstartime and load new data based on it. But this logic is not working. Basically I want to...

Hi All, I need some help with some information on mapping variables and parameters. I have read the manuals and I know theoretically what it means. But could you give me an example of where I would use it best. And where do I store the parameter file? Is it in the Informatica Server? I...

Ties Blom, I created the target table in Informix. I only need to extract some of the columns from the source DB2/AS400, so I created the table in informix using these limited columns. And then I loaded from the Source to the target. I am not sure how exactly I should be creating the PM key...

I have a source in DB2/AS400 and target in Informix. The source doesn't have any PM key or any unique key. All the columns contain dublicate datas, or it is not unique. I want to implement incremental load for the target table. But I am not sure on how to implement this since nothing in the...

Hi All, I have a source in DB2, and my target is Informix. The tables have the same columns,datatype,PM keys.I have used a lookup to lookup the two unique columns from the target which has the composite PM key. And I am using a filter to filter only the new data based on the lookup. I did some...

I am trying to send an email to myself after the workflow is successful/unsuccessful. I read in the Informatica manual that I can use a command task to include an email task in the workflow. I know how to create a command task, but I don't know what unix script I should be putting to send an...

I need to delete three days(sysdate-2, sysdate-3, sysdate -4) data from my target table. Then I need to update three days (sysdate-3,sysdate-2,sysdate-1)data from the source table. How do I accomplish this? Is there a way to use the pre sql in Target properties to delete rows for three dates...

I am trying to import a DB2 source. But I am not seeing any tables even after I have established connection with the DB2 server, port no.,with the right logins. Am I missing something? The source I am trying to pull is in production. What reasons can there be for me not to see the tables when...