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 and make two groups with the below conditions :
Group1 Condition : Mod ( Col, 10) = 0
Group2 Condition : Mod ( Col, 10) = 1
So first Group will allow data like 10,20,30,40.....
and 2nd group will allow 11,21,31,41,51.....
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
which one is better performance wise joiner or look up
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Explain the difference between a data warehouse and a data mart?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What do you understand by SOA of Informatica?
In how many ways we can create ports?
Slowly changing dimensions, types and where will you use them
list out all the transformations which use cache?
How can repository reports be accessed without sql or other transformations?
Explain what transformation and how many are there in informatica?
what are the deliverables?in your project?
Write the different tools in the workflow manager?
Explain constraint based loading in informatica
What is the Process to creating lookup transformation in informatica
Under what condition selecting sorted input in aggregator may fail the session?