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
root tree will find which is server job and which is parallel job?
What are routines in datastage? Enlist various types of routines.
Enlist various types of routines in datastage.
Differentiate between datastage and informatica?
Why fact table is in normal form?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
What are the repository tables in datastage?
how do u catch bad rows from OCI stage? And what CLI stands for?
How many areas for files does datastage have?
Explain the importance of surrogate key in data warehousing?
What is difference between symmetric multiprocessing and massive parallel processing?
Define Merge?
What is the method of removing duplicates, without the remove duplicate stage?
Define orabulk and bcp stages?