100 records in source and i have 3 targets, my requirement
is first record insert into 1st target,2 record into 2nd
target,3 record into 3rd target and again 4th record into
1st target like dat..how to implement dis?
- 3 Answers
- 10370 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / manthiramoorthy. g
SQ-->EXP-SEQ-RTR-TARGETS
Router
=======
Make 3 Groups
MOD(NEXTVAL,3) = 0
MOD(NEXTVAL,3) = 1
MOD(NEXTVAL,3) = 2
| Is This Answer Correct ? | 13 Yes | 2 No |
Post New Answer View All Answers
What is a rank transform?
Explain the pipeline partition with real time example?
What are the components of workflow manager?
COM components can be used in Informatica
What are the new features of informatica 9.x at the developer level?
Repository user profiles
What is the difference between informatics 7x and 8x and what is latest version?
What are the designer tools for creating transformations?
What is a sequence generator transformation?
How to load last n records of file into target table - informatica
What is depict expression change?
What is sequence generator transformation in informatica?
How can we delete duplicate rows from flat files?
Target increases every day even though no new record was inserted
what is informatica metadata?
