Interested to Buy Any Domain ? << Click Here >> for more details...
following scenario i have 1000 record flatfile source i
want ist row to ist target 2nd eow to 2nd target 3rd row to
3rd target how will u do?
- 7 Answers
- 10801 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / rakesh
use a Sequence Generator to generate a column NUM
in Router 1st Group: MOD(NUM,3)=1
2nd Group: MOD(NUM,3)=2
3rd Group: MOD(NUM,3)=0
Im not sure about MOD format, but this idea will workout..
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
What are the restrictions of union transformation?
Global and Local shortcuts. Advantages.
What are batches?
Explain the code page compatibility?
What are the issues you have faced in your project? How did you overcome those issues?
What does refresh system mean, and what are its distinctive choice?
What is a joiner transformation?
What are the mapping parameters and mapping variables?
What is a passive transformation?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What is a grid in Informatica?
What do you mean by blocking transformation?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What is a code page?
Can you use flat files in Mapplets.
