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 |
where to select code page option?
What is a repository manager?
How can one identify whether mapping is correct or not without connecting session?
What does cheating measurement mean?
What is a pre-defined event and user-defined event?
write s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3
How to delete the (flat file) data in the target table after loaded.
with out using update strategy transnsformation how to update the data in mapping level
what is the difference between lookupoveride and joiner?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
How many mapplets u have created? and what is the logic used
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment? Please explain in depth thanks in advance