Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4802 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
list out all the transformations which use cache?
Explain about cumulative Sum or moving sum?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What is lookup transformation?
Plz can any one say me how to get the informatica certification materials and dumps
How many types of sessions are there in informatica.please explain them?
What do mean by local and global repository?
What are the different options available for update strategy?
State the differences between sql override and lookup override?
What are the data movement modes in informatica?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Why filter transformation is an active one?
What is the scenario which compels informatica server to reject files?
In informatica workflow manager, how many repositories can be created?
