how can we send even and odd records from a sequential file
to two different targets
Answer Posted / deepu
we can use transfarmer stage,in the stage create surgatekey
and write constraint like mod(<surcatekeycolumn>/2)=0 in
one link and mod(<surgatekeycolumn>/2)=1 in another link.we
get even records and odd records
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Name the different sorting methods in datastage.
What is ds designer?
What are some different alternative commands associated with "dsjob"?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
What is the difference between datastage and datastage tx?
What are the features of datastage flow designer?
What are the types of containers and how to create them?
table actions available in oracle connector?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
Define Job control?
Notification Activity
How do you import and export the datastage jobs?
If you want to use a same piece of code in different jobs, how will you achieve this?
What is the process of killing a job in datastage?
What are routines in datastage?