Interested to Buy Any Domain ? << Click Here >> for more details...
I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output
- 6 Answers
- 12557 Views
- TCS, I also Faced
- E-Mail Answers
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
How a routine is called in datastage job?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
What is the roundrobin collector?
What are the areas of application?
How do you register plug-ins?
What is the precedence of stage variables,derivations, and constraints?
how to sort two columns in single job in datastage.
How do you start developing a datastage project?
What is the importance of the exception activity in datastage?
how can we create rank using datastage?what is the meaning of rank?
Define orabulk and bcp stages?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
What are the functionalities of link partitioner?
What is a folder? Difference types of stages?
Describe stream connector?
