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
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
Can you explain repository tables in datastage?
What are the types of containers?
What is a quality stage in datastage tool?
Explain ibm infosphere information server and highlight its main features?
What could be a data source system?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What is the purpose of pivot stage?
what are the errors,warnings in datastage
What are orabulk and bcp stages?
How many types of stage?
How do y read Sequential file from job control?
Differentiate between hash file and sequential file?
What is "fatal error/rdbms code 3996" error?
explain about citrix scheduling tool in datastage