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
- 3944 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 |
If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?
in performance wise union is past,union all is past
Where is metadata stored?
How to recover the standalone session?
what is degenerated dimension?
I am Unable to load the FixedWith FlatFile Into The Target.What Is The Reason. PLZ Help Me..
What are the challenges you have faced in your project?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Can you create a flatfile target
what r the values tht r passed between informatics server and stored procedure?
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.
what are the settiings that u use to cofigure the joiner transformation?
Teradata 
