Hi This is Vijay,
How can your remove the duplicates in sequential File?
Answer Posted / arun
Sort the incoming data using a sort stage & use remove
duplicates on the key columns. This will remove the
duplicates in ur source file.
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
Nls stands for what in datastage?
What are routines in datastage?
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 to export or import the jobs in .ISX file
Can you explain link buffering?
What is difference between symmetric multiprocessing and massive parallel processing?
What are the steps required to kill the job in Datastage?
What are the different type of jobs in datastage?
Have you used Unstructured data?
Which algorithm you used for your hashfile?
What is use Array size in datastage
what is the use of skid in reporting?
What are the types of hashed files in data stage
What are the types of views in datastage director?
Can you define merge?