Source as
1
1
2
2
3
3
How to get target as 1 2 3
and
1
2
3
Answer Posted / anu
take sequence annd router t/r 's
connct nextval port to router
create one group mod(nextval , 2)=0-------target1
default group-----------------------------target2
this is applicable to above six source rows only
this is my second logic
tell me any corrections
Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
How to handle decimal places while importing a flatfile into informatica?
What all join we can perform in LOOKUP transformation?
How to update source definition?
Explain how to import oracle sequence into informatica?
What are the various types of transformation?
Can anyone tell me the new features in Informatica 9 Version?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
What are the measure objects?
Explain sessions. Explain how batches are used to combine executions?
What is the way to execute pl/sql script using informatica mapping?
Explain the mapping variable usage example in informatica
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is the maplet?
What's the layout of parameter file (what does a parameter file contain?)?