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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.