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


Please Help Members By Posting Answers For Below Questions

On which interface you will be working as a developer?

639


What are the stages in datastage?

637


What are the main differences you have observed between 7.x and 8.x version of datastage?

624


What is the difference between in process and inter process?

669


What are the various kinds of containers available in datastage?

564






file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

538


How to clean the datastage repository?

696


how to write server Routine coding?

1665


how to export or import the jobs in .ISX file

721


What are the functionalities of link partitioner and link collector?

595


What is difference between join, merge and lookup stage?

638


How to read the length of word in unix?

886


Differentiate between hash file and sequential file?

584


Define APT_CONFIG in Datastage?

666


How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

1701