I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output
- 6 Answers
- 10204 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / sushil
SeqFile---->Tranfrmr----->TGT
To number of rows in a sequential file in Transformer we
can use @INROWNUM, store value in variable ROW_NUM and then
by providing condition as same condition as:
ROW_NUM = '10' and ROW_NUM = '11' we can skip such records.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
What is a merge in datastage?
Can you explain repository tables in datastage?
How do you remove duplicate values in datastage?
Highlight the main features of datastage?
In Datastage, how you can fix the truncated data error?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
I have a few records just I want to store data in to targets cycling way how?
how to abort the job its matain duplicates?
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 to use self join using datastage ? can u tell me using stage how can we implemnet the self join
Name the different types of Lookups in Datastage?
What are the functionalities of link partitioner?
How complex jobs are implemented in datstage to improve performance?
How to perform incremental load in datastage?
