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
- 11980 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
Can you explain engine tier in information server?
What are the types of containers and how to create them?
Where the datastage stored his repository?
Can you implement SCD2 using join, transformer and funnel stage?
What is meta stage?
Name the different sorting methods in datastage.
I have a few records just I want to store data in to targets cycling way how?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
What are the benefits of datastage?
What are stage variables, derivations and constants?
What are the different options associated with dsjob command?
how can we create rank using datastage?what is the meaning of rank?
Why do we use link partitioner and link collector in datastage?
What is "fatal error/rdbms code 3996" error?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
