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 / sufi
Use router with two groups with the below conditions:
Group1 condition : Mod( Col, 10) = 0
Group2 condition : Mod ( Col, 10) = 1
Group1 will allow data like 10,20,30,40....
Group2 will allow data like 11,21,31,41....
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is a repository? And how to add it in an informatica client?
my source is junk data how will u remove that junk data by using unix please any one replay me
What are the different components of powercenter?
Define sessions in informatica etl?
Enterprise data warehouse your projects phase by phase explain?
Partition, what happens if the specified key range is shorter and longer
How many input parameters can exist in an unconnected lookup?
What is a repository manager?
How to extract the informatica rejected data?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Why sorter is an active transformation?
What is the difference between stop and abort in informatica
Write the unconnected lookup syntax and how to return more than one column.
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are the new features of informatica 9.x at the developer level?