Page 1 of 1

Alternate Records to one target and remaining other target

Posted: Wed Jun 20, 2012 1:43 am
by jhansi
I Want to send Alternate Records to one target and remaining other target without using transformer.

source
deptno,sal
1,2000
2,3000
3,4000
1,2300
4,5000
5,1100

target1
deptno,sal
1,2000
3,4000
4,5000
target2
deptno,sal
2,3000
1,2300
5,1100

Posted: Wed Jun 20, 2012 3:42 am
by vamsi.4a6
This job design would work

Seq file ---> peek stage---2 o/p files

1) In peek stage make the node map constraint in such a way that it run on 2 nodes
2) Pass the o/p of the peek stage to the 2 o/p files
3) Make the partition for peek stage as round robin so that alternate data goes into diff seq files
4) Peek the output as node 0 for one file and node 1 for the other file

Please correct me if this wrong