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
- 10409 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
server hot-ws270 is connect to Repository B. What does it mean?
pmscmd startworkflow -sv
Describe data concatenation?
What is meant by query override?
Enlist few areas or real-time situations where informatica is required.
What is domain in terms of informatica?
how many types of dimensions are available in informatica?
What is sequence generator transformation in informatica?
How union transformation is used?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
On which transformations you created partitions in your project?
Mention a few design and development best practices for informatica?
How to improve the performance of a session using sorter transformation?
What are some examples of informatica etl programs?
What is mapplet in informatica?
