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
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
How the ipc stage work?
Define repository tables in datastage?
What is data partitioning?
What are the types of jobs we have in datastage?
How can we improve performance of data stage jobs?
Different ways a project can be moved to production ?...example ….export-import and Version control.
What are the primary usages of datastage tool?
What is the importance of the exception activity in datastage?
Is it possible to query a hash file?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
What are routines in datastage? Enlist various types of routines.
What are some prerequisites for datastage?
How one source columns or rows to be loaded in to two different tables?
What is the method of removing duplicates, without the remove duplicate stage?