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
- 4801 Views
- HCL, I also Faced
- E-Mail Answers
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 |
write a query to follwoing table amount year quarter 254556 2003 first 546332 2003 second 129034 2003 third 490223 2003 fourth 165768 2004 first 265443 2004 second 510412 2004 third 435690 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 254556 546332 129034 490223 2004 165768 265443 510412 435690
What is joiner change?
What is the use of source qualifier?
How to load dimension and fact in same mapping at same time.explain me the logic used for that scenario.
Explain the flow of data in Iinformatica?
Difference between task flow and linear task flow
where is the reject loader .
Explain the use of aggregator cache file?
any body can say about all versions of informatica ?how many versions ?
enterprise datawarehouse your project phase by phase explain?
What are the types of maping in Getting Started Wizard?
What are the different ways to implement parallel processing in informatica?
Teradata 
