Anupam Kumar

• Apr 8th, 2016

 

Attach sequence with data. In Router create three group and put condition 1. seq.val<=250000. 2. seq.val>=250001 AND seq.val<=500000 and 3. seq.val>=500001 AND seq.val<=7500000

Savitri

• Apr 21st, 2016

 

Use sequention generator and divide groups in router 1st grp < 2500001 sec grp < 5000001.

KUMAR

• May 13th, 2016

 

src to SORTER---> AGG---->SEQ---->EXP---> router
in router create 3 groups s1 s2
condition if sno <=count/4
condition if sno > cont/4 and <=count/2
DEFAULT--> TAKE A ROUTER
CREATE A GROUP S3
SNO = COUNT/2

Venkat

• Jun 13th, 2016

 

Pass Source qualifier to Expression

Expression Condition
Variable port(V_COUNT) - IIF(V_COUNT < = 75000,1,V_COUNT+1)
O/P (Port segregation) - decode(true, V_COUNT < = 25000,1
V_COUNT>25000 and V_COUNT < = 50000,2
V_COUNT>50000,3,NULL)

V_COUNT will generate sequence number (1 to 75000) for entire record set,
Once it reaches 75000 again it will triggered back to 1

Output port will generate 1/2/3 respective values based on V_COUNT details.

Now create 3 ports in Router and divert to O/P based on numbering 1/2/3

vinit

• Jun 22nd, 2016

 

(SQ + Seq Gen) ---> Exp ---> sorter ----> router (having four groups for seq gen port) ---> four targets