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?
- 1 Answers
- 3960 Views
- HCL, I also Faced
- E-Mail Answers
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
Explain direct and indirect flat file loading (source file type) - informatica
How many types of sessions are there in informatica.please explain them?
What is the use of target designer?
How to implement security measures using repository manager?
What is mapping debugger?
Under what condition selecting sorted input in aggregator may fail the session?
What are the popular informatica products?
What is the benefit of session partitioning?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Define update strategy?
Where can we find the throughput option in informatica?
Could you explain what is enterprise data warehouse?
Why update strategy and union transformations are active? Explain with examples.
What is the Process to creating lookup transformation in informatica
How to update source definition?
