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
- 34794 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
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
What are the different types of lookups in datastage?
What is the difference between account and directory options ?
whom do you report?
What are the various kinds of containers available in datastage?
what is repositery?
How can we improve the performance in datastage?
What is difference between join, merge and lookup stage?
What is the difference between the local container and shared container?
Describe the architecture of datastage?
What is job control?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
how to write server Routine coding?
State the difference between an operational datastage and a data warehouse?
