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
What is the difference between datastage and datastage tx?
Define data aggregation?
What can we do with datastage director?
What is a merge?
What is the process of killing a job in datastage?
What is size of a transaction and an array means in a datastage?
What are the types of containers in datastage?
How a server job can be converted to a parallel job?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
What is merge stage?
what is flow of project?
CHANGE CAPTURE
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
What is the difference between hashfile and sequential file?