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
What is the sortmerge collector?
How many types of stage?
What is a merge?
Define orabulk and bcp stages?
What is the purpose of pivot stage and types of containers in datastage
Which commands are used to import and export the datastage jobs?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
How do you start developing a datastage project?
What is ibm datastage?
What are the areas of application?
Can you explain kafka connector?
What is the difference between informatica and datastage?
What is "fatal error/rdbms code 3996" error?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?