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 / 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 |
What are variable ports and list two situations when they can be used?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation than the aggrator? if yes how?
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
Dovelopment work (mapings,workflows)and unit testing also done in informatica ,then wt we do ? pls give me detail?
What is difference between maplet and reusable transformation?
i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?
I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.
Explain the informatica workflow?
in static and dynamic which one is better
What do you understand by a term domain?
what is degenerated dimension?