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
- 12551 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 repositery?
What is apt_config in datastage?
What are the enhancements made in datastage 7.5 compare with 7.0?
how do u catch bad rows from OCI stage? And what CLI stands for?
What is the difference between informatica and datastage?
What is "fatal error/rdbms code 3996" error?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
Give an idea of system variables.
Name the third party tools that can be used in datastage?
How many areas for files does datastage have?
What is the difference between account and directory options ?
What are the different layers in the information server architecture?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
What are the some differences between 7.x and 8.x version of datastage?
What is merge stage?
