Hi This is Vijay,
How can your remove the duplicates in sequential File?
Answer Posted / charan
hi this is charan
in sequential file there is no distinct keyword.But we use sequential file properties reject mode=output and then use remove duplicate stage based on key column(here we can't store the duplicate records).
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
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 ?
what is repositery?
Why fact table is in normal form?
How you can fix the truncated data error in datastage?
What is a ds designer?
Enlist various types of routines in datastage.
How do you import and export data into datastage?
What is the method of removing duplicates, without the remove duplicate stage?
I have a few records just I want to store data in to targets cycling way how?
Define Job control?
How do you register plug-ins?
What is the command line function to import and export the ds jobs?
Explain connectivity between datastage with datasources?
What is datastage?
What is the difference between an operational datastage and a data warehouse?