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
11377 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

Is stop and abort are same in informatica?

947

Explain scd type 3 through mapping.

917

What is union transformation?

907

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

982

Can we create two repositories on same database instance in oracle?

1015

What are the types of caches in lookup?

975

What is update strategy transform?

1015

What all join we can perform in LOOKUP transformation?

914

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

2306

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

1997

can u give example for factless fact table

6442

How can we handle two sessions in informatica?

982

What is the sequence generator transformation in informatica?

1093

explain abt ur project architecture?

2122

Explain the code page compatibility?

1021