I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output
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
How you can fix the truncated data error in datastage?
How many types of hash files are there?
What are the types of jobs we have in datastage?
What is size of a transaction and an array means in a datastage?
What are the steps required to kill the job in Datastage?
how many rows sorted in sort stage by default in server jobs
what is ds administrator used for?
What is job control?
What a datastage macro?
How will you move hashed file from one location to another location?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
Where do you see different stages in the designer?
Can you define merge?
What are the types of containers in datastage?
Define Merge?