Hi experts ,I have a Source of 1000 records.I have to load
100 records in first target,101 to 200 records in 2nd
target, 201 to 300 records in 3rd target and again 301 to
400 in first target like that as cyclick process. How can i
acheive this.
Answer Posted / anu
take sequence generator connect neval port to router
in router create 3 groups
in 1st group (nextval<=100) or (nextval>300 and nextval<=400)
or (nextval>700 and nextval<=800)........trg1
in 2nd group (nextval>100 and nextval<=200) or (nextval>400
and nextval<=500) or (nextval>800 and nextval<=700)......trg2
in 3rd group (nextval>200 and nextval<=300) or (nextval>500
and nextval<=600) or (nextval>900 and nextval<=1000)......trg3
Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
State the differences between sql override and lookup override?
Is there any target staging area in informatica not staging area
What are the measure objects?
which one is better performance wise joiner or look up
What is joiner transformation in informatica?
What are the differences between source qualifier and joiner transformation?
Mention few power centre client applications with their basic purpose?
What is an active transformation?
What is the use of transformation?
What are active and passive transformations?
What is session task and command task?
What is olap (on-line analytical processing?
Differentiate between a repository server and a powerhouse?
Different circumstance which drives informatica server to expel records?
What is the meaning of up gradation of repository?