My i/p is 1,2,3,4,5,6,7,8,9,10………..
o/p to be populate in two tables as below.
o/p1: 10,20,30,40,50,60,70,80,90…….
o/p2: 11,21,31,41,51,61,71,881,91…….
Answer Posted / abhinaw prakash
The other approach would be to concatenate the incoming values with '0' and '1' in expression variable port and move it to different targets using Router.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Explain lookup transformation source types in informatica
What is a repository manager?
How to load data in informatica ?
Does an informatica transformation support only aggregate expressions?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What is the maplet?
Explain the code page compatibility?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What is option by which we can run all the sessions in a batch simultaneously?
How an expression transformation differs from aggregator transformation?
Is it possible to create multiple domains on a single Informatica server?
What are the differences between source qualifier and joiner transformation?
What do think which one is the better joiner or look up?
Define sessions in informatica etl?