how can we send even and odd records from a sequential file
to two different targets
Answer Posted / varma
In transformer specify constraints Mod(@INROWNUM,2) =1 for Odd records and Mod(@INROWNUM,2) = 0 for even records.
| Is This Answer Correct ? | 41 Yes | 2 No |
Post New Answer View All Answers
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
How to reverse the string using unix?
What is ibm datastage?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
how to sort two columns in single job in datastage.
how to run a sequential file stage in parallel if the stage is used on the TARGET side
What is datastage engine?
How we can covert server job to a parallel job?
What are stage variables?
Demonstrate experience in maintaining quality process standards?
What is staging variable?
AGGREGATOR default datatype
How do you remove duplicate values in datastage?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
What is ibm datastage flow designer?