Hi This is Vijay,
How can your remove the duplicates in sequential File?
Answer Posted / venugopal
Hi Vijay it's simple
In the source sequential file goto Output->Properties
under options you mention reject mode = Output.
This will gives the duplicate records in the output.
This will 100% work why because in my present project we
are using the same format.
| Is This Answer Correct ? | 3 Yes | 10 No |
Post New Answer View All Answers
What are the types of containers?
why do u need the IOS upgradation in a FC switch
What are the types of jobs we have in datastage?
How to manage date conversion in Datastage?
What are the different type of jobs in datastage?
Can you explain tagbatch restructure operator?
how to delete one row in target dataset
What is staging variable?
CHANGE CAPTURE
How complex jobs are implemented in datstage to improve performance?
What is the project in datastage?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
Define APT_CONFIG in Datastage?
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
Where do the datastage jobs get stored?