SQ-->EXP-SEQ-RTR-TARGETS Router ======= Make 3 Groups MOD(NEXTVAL,

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?

Question Posted / manthiramoorthy. g

3 Answers
11657 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

Please Help Members By Posting Answers For Below Questions

What is joiner transformation in informatica?

1097

How to extract sap data using informatica?

1086

What is workflow monitor?

1099

Where do we use mapping variables in informatica?

1118

What are the components of Informatica? And what is the purpose of each?

1108

What is a pre-defined event and user-defined event?

1078

What is informatica? Why do we need it?

1162

What is a mapplet/worklet in informatica?

1242

In informatica workflow manager, how many repositories can be created?

1435

How we can use union transformation?

1099

What is the difference between router and filter?

1366

How to load a Dimension ? and how to load a fact table?

1458

What do you mean by blocking transformation?

1115

have u done any performance tuning? how u ll do?

2362

How can you define user defied event?

1073