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
- 11976 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 are the repository tables in datastage?
What is the different type of jobs in datastage?
How to perform incremental load in datastage?
On which interface you will be working as a developer?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
How do you start developing a datastage project?
Difference between in process and inter process?
How to find value from a column in a dataset?
EXPLAIN SCD
Can you explain tagbatch restructure operator?
Have you have ever worked in unix environment and why it is useful in datastage?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
How can we improve the performance in datastage?
What are the features of datastage flow designer?
How and where you used hash file?
