Interested to Buy Any Domain ? << Click Here >> for more details...
how do u capture duplicates through sort & transformer
- 4 Answers
- 18757 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 |
Explain the situation where you have applied SCD in your project?
diff between OLTP and OLAP? what TOP-DOWN and BOTTOM-UP Approach? which is best? what are Star Schema and Snow Flake Schema?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
What is Horizontal transformation, vertical transformation,diagonal transformation?
How do u view log file for a particular job?
What are the third party tools you used in your project?
CAN WE DECLARE DATASET SET WITH OTHER THAN .DS EXTENTION OR NOT IF YES WHAT IS THE DIFFERENCE U FIND?IF NOT WHY?
Name the third party tools that can be used in datastage?
What are the types of views in datastage director?
what is A Datastage?
can a fact table contains textual information
6 Answers HCL, HCL BSERV, IBM,
What a datastage macro?
Teradata 
