Interested to Buy Any Domain ? << Click Here >> for more details...
how do u capture duplicates through sort & transformer
- 4 Answers
- 18684 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 |
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?
what are the different type of errors in datastage?
Source flat file contains src --- 1 2 ' ' ' 18 we had 3 targets T1 T2 T3 -- -- -- 1 4 7 2 5 8 3 6 9 10 13 16 11 14 17 12 15 18 How can i get? **Using only datastage, but not unix or any other. I am expecting the answer soon.. Thanks in advance.
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
What is ibm datastage flow designer?
How many types of stage?
what is the differeces between hash and modulus partition methods
what is the difference between INROWNUM AND OUTROWNUM IN DATASTAGE SERVER EDITION?
what is A Datastage?
Explain the situation where you have applied SCD in your project?
What is exact difference between Parallel Jobs and server Jobs..
what is a force compile
Teradata 
