1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

how do u capture duplicates through sort & transformer

Question Posted / raam

Answers were Sorted based on User's Feedback



how do u capture duplicates through sort & transformer..

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

how do u capture duplicates through sort & transformer..

Answer / subhash

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

how do u capture duplicates through sort & transformer..

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 do u capture duplicates through sort & transformer..

Answer / kalyanreddy

Yes, Kirans is right

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Data Stage Interview Questions

Scenario : I have 2 jobs say job A and Job B with parameters x and y respectively. I need to create a sequence job. If we pass parameter x then Job A should run, If we pass parameter y then Job B should run, if we dont pass any parameter then Both Job A & B should run.

4 Answers   iGate, Thirdware,

project Steps,hits, Project level HArd things,Solved methods?

0 Answers   Hexaware,

for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

0 Answers  

j1,j2,j3 jobs r runing iwant to run j1,j3 after j2 how to do this using sequencer? 2)j1,j2,j3 jobs r runing iwant to run j1,j2,j3 how to do this?

1 Answers   Wipro,

What is the default padding character?

3 Answers   IBM,




how to retrive the max(sal),deptno,empno in datastage?

13 Answers   Polaris,

How to create environments and call them? What is the use defined variables?

2 Answers   HCL, ME,

Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result "SCH-AS" in onee column and "1010" in another column.. Can any one tell the answer...

5 Answers  

data stores in which location while using data set stage as the target?

1 Answers   IBM, TCS,

What is a merge?

0 Answers  

i have a scenario with i/p as ID,salary with values 1,1000 2,2000 and 3,4000 i need an extra column in the o/p named amount with values 2000,4000 and NULL. how can i get it?

2 Answers   L&T,

if we take 2 tables(like emp and dept), we use join stage and how to improve the performance?

5 Answers   Cap Gemini,

For more Data Stage Interview Questions Click Here
Categories