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
How we can use union transformation?
how to load rows into fact table in data warehouse
What is an expression transformation in informatica?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is joiner transformation in informatica?
According to his methodology what all you need before you build a datawarehouse
What is the difference between informatica 7.0 and 8.0?
what is Active lock explain
Enlist the various types of transformations.
What is the difference between writing a joiner query in ANSI style and THETA style?
Which transformation is needed while using the Cobol sources as source definitions?
How to load the data from people soft hrm to people soft erm using informatica?
Whats the difference between informatica powercenter server, repositoryserver and repository?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Explain incremental aggregation in informatica