Interested to Buy Any Domain ? << Click Here >> for more details...
how do u capture duplicates through sort & transformer
- 4 Answers
- 18932 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 |
SOURCE LIKE I_D,F1,F2 --------- 100,N,Y 100,N,N 100,Y,N 101,Y,Y 101,N,Y 102,Y,N 103,N,N 104,Y,Y 105,N,N 106,N,Y 102,N,Y 105,Y,Y O/P LIKE ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y
What is a range lookup?
Hi all, explain one complex business rule that you had in your project and how did you accomplish it using DS?
what is the use of invokation id
how to create document in datastage?
Can you explain kafka connector?
if a column contains data like abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc, roy,pwe,aaa,xxx,xyz,roy,xok.... how to send the unique data to one source and remaining data to another source????
where the log files or tables can store in DS?
CAN ANY ONE TELL ME THE ARCHITECTURE OF DATASTAGE CLEARLY....
What are datastage sequences?
can any 1 put a difference between datastage 7.5 and 8.0 all concepts plz r mail 2 me anu4u09@gmail.com
i have seq file that contents 10 million records load to target any data base.. in that case it takes lot of time for loading..how do performance tuning in that situation...?
Teradata 
