how do u capture duplicates through sort & transformer
Answer Posted / harikiran
in transformer stage output properties tab there is a
sorting option if u mention sort option there are two more
operations are there like unique and stable sort. if u
click on uniqu it will restrict the duplicates
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
AGGREGATOR default datatype
Differentiate between hash file and sequential file?
Can you highlight the main features of ibm infosphere information server?
what is use of SDR function?
Can we use target hash file as a lookup ?
What is the use of datastage director?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What is difference between symmetric multiprocessing and massive parallel processing?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
Is possible to create skid in dim,fact tables?
Difference between data warehousing and olap?
Does datastage support slowly changing dimensions ?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do