i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?
Answer Posted / harish konda
1. Declare workflow and mapping variables and assign them in Pre and Post session.
2. Use Transaction control transformation to create the target files dynamically.
Like everytime you run the session you can create the target file with the value of mapping variable as a run number.
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
update strategy transformation in informatica
Parameter and variable differences
What is an active transformation?
How can we handle two sessions in informatica?
How might you approve all mappings in the archive all the while?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is a pre-defined event and user-defined event?
What is incremental aggregation?
While migrating the data from one environment to another environment how would you manage the connections?
What are the advantages of using informatica as an etl tool over teradata?
Why sorter is an active transformation?
Mention few power centre client applications with their basic purpose?
What is persistent lookup cache?
What is the use of an aggregator cache file?