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
What are transforms and what is the differenece between routines and transforms?
Demonstrate experience in maintaining quality process standards?
How many Key we can define in remove duplicate stage?
What is the use of datastage director?
What is ds designer?
Where do you see different stages in the designer?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
What is orabulk stage?
What all are the different way to run a job?
How rejected rows are managed in datastage?
Triggers,VIEW,Procedures
How a server job can be converted to a parallel job?
Difference between in process and inter process?
what is flow of project?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?