Interested to Buy Any Domain ? << Click Here >> for more details...
how can we send even and odd records from a sequential file
to two different targets
- 10 Answers
- 35139 Views
- IBM, iGate, TCS, I also Faced
- E-Mail Answers
Answer Posted / subhash
SeqFile--->Transformer=====>TGTFile1,TGTFile2
1. in SeqFile, add the 'Row Number Column' property and
name it as 'Row_Number'
2. in the Transformer, give the constraint for TGTFile1
link:
'MOD(Row_Number,2)=1'----> all the ODD rows
give the constraint for TGTFile2 link:
'MOD(Row_Number,2)=0'----> all the even rows.
If we use INROWNUM in transformer, then we need to run the
transformer on 'Single' NODE configuration.
| Is This Answer Correct ? | 18 Yes | 0 No |
Post New Answer View All Answers
How to clean the datastage repository?
What a datastage macro?
table actions available in oracle connector?
How do you start developing a datastage project?
What is the difference between odbc and drs stage?
What is the method of removing duplicates, without the remove duplicate stage?
Differentiate between Join, Merge and Lookup stage?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
What is use Array size in datastage
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
what is 'reconsideration error' and how can i respond to this error and how to debug this
How do y read Sequential file from job control?
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?
How many areas for files does datastage have?
What is usage analysis in datastage?
