I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output
Answer Posted / ankit gosain
Hi,
You can block any specified record(s) from the source seq.
file with the help of a Transformer Stage.
Source Seq. File ----> Transformer ---->Target Seq. File
Now, in Transformer stage create a Stage Variable (say
row_num) & initialize it with ZERO.
In it's derivation, just increment it by ONE (i.e.
row_num+1)
Now, Insert a new column in the output & it's derivation,
assign the variable (row_num).
Now, in the contraint tab wirte row_num<>10 OR row_num<>11
If you have some other doubts or queries, you can mail me
on ankitgosain@gmail.com
Cheers,
Ankit :)
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is a datastage job?
How we can covert server job to a parallel job?
What could be a data source system?
What is the difference between server job and parallel jobs?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
What is the purpose of interprocessor stage in server jobs?
What is meta stage?
Define ds designer?
How many types of hash files are there?
Can you highlight the main features of ibm infosphere information server?
How can we improve performance of data stage jobs?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
Why do we use exception activity in Datastage?
What is the purpose of pivot stage?
What are some prerequisites for datastage?