Interested to Buy Any Domain ? << Click Here >> for more details...
I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output
- 6 Answers
- 12303 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / subbuchamala
SeqFile---->Tranfrmr----->TGT
in Seq file we can add 'ROW NUMBER COlumn' as ROW_NUM which will numbers to each row.
we add 2 parameters to the job: RowNum1, RowNum2
in transformer, in the constrain we can specify below condition:
ROW_NUM<>RowNum1 OR ROW_NUM<>RowNum2
then we can skip those two records.
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
What is quality stage?
What is the roundrobin collector?
How can we improve performance of data stage jobs?
Explain ibm infosphere information server and highlight its main features?
How a source file is populated?
What is the use of datastage director?
Define 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 types of sorting methods are available in datastage?
How and where you used hash file?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
explain about citrix scheduling tool in datastage
What is the difference between Datastage 7.5 and 7.0?
in oracle target stage when we use load option and when we use upsert option?
Define Data Stage?
