Interested to Buy Any Domain ? << Click Here >> for more details...
how do u capture duplicates through sort & transformer
- 4 Answers
- 18924 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kiran
Hai..,
In sort stage we have one property...its create key change
column.
In Transformer stage ,we have to write if then else
condition.....
| Is This Answer Correct ? | 11 Yes | 1 No |
In sort stage, we have 'create key change
column' property.
i.e, The KeyChange column is set to 1 for the first record
in each group where the value of the sort key changes.
Subsequent records in the group have the KeyChange column
set to 0.
In Transformer stage ,we can put constraint as IF KeyChange
= 1 then map to the TGT.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / 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 |
Describe routines in datastage? Enlist various types of routines.
how to get the unique records on multiple columns by using sequential file stage only
What is mapping?
How can we improve performance of data stage jobs?
Define orabulk and bcp stages?
what is use of SDR function?
Can you explain kafka connector?
What is a quality stage?
How u implement the slowly changing dimensions if my source table is consisting of cid,cname,add,phno,email but i need to capture the changes for first three columns how u implement?
How to enter a log in auditing table whenever a job get finished?
what is hash file
what is the difference between the join and look up explin me one exmple
Teradata 
