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
how many rows sorted in sort stage by default in server jobs
What are the components of ascential data stage?
What is difference between symmetric multiprocessing and massive parallel processing?
How to read multiple files using a single datastage job if files have the same metadata?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
How a source file is populated?
What is size of a transaction and an array means in a datastage?
What are the steps needed to create a simple basic datastage job?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
how to sort two columns in single job in datastage.
What all are the different way to run a job?
How do you schedule or monitoring the job?
How to find value from a column in a dataset?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
How can you write parallel routines in datastage PX?