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
Define data aggregation?
What are system variables and sequencers in datastage
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
what are the devoleper roles in real time? plz tell i am new to datastage....
Can you explain tagbatch restructure operator?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
What are the functionalities of link partitioner and link collector?
How do y read Sequential file from job control?
Can you implement SCD2 using join, transformer and funnel stage?
On which Dimension Table you implemented SCD Type in your Project
In Datastage, how you can fix the truncated data error?
what is the use of skid in reporting?
What is the precedence of stage variables,derivations, and constraints?
What is process model?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS