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
- 12306 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 to Remove Duplicate using SQL?
How do you import and export the datastage jobs?
How to read the length of word in unix?
What are the differences between datastage and informatica?
What are the different types of lookups in datastage?
How one source columns or rows to be loaded in to two different tables?
Define data aggregation?
What are orabulk and bcp stages?
what is flow of project?
What is the difference between in process and inter process?
how to add a new records into source?
Highlight the main features of datastage?
CHANGE CAPTURE
What are data elements?
What all the types of jobs you developed?
