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
Alternate Records to one target and remaining other target
Moderators: chulett, rschirm, roy
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
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