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
- 34839 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
Explain usage analysis in datastage?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
how to add a new records into source?
what is 'reconsideration error' and how can i respond to this error and how to debug this
Define ds designer?
What can we do with datastage director?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
Can you explain kafka connector?
What is oci?
how to implement scd2 in datastage 7.5 with lookup stage
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
How do you generate sequence number in datastage?
Define Merge?
Is it possible to query a hash file?
Triggers,VIEW,Procedures
