Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

how do u reduce warnings

1 Answers   CGI,

What are the main differences you have observed between 7.x and 8.x version of datastage?

0 Answers  

WHAT IS FORCE COMPILE?

3 Answers   FIS, HCL, Polaris,

1)What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?

1 Answers   Hexaware,

hi, how would i run job1 then job 3 , then job2 in a sequence of job1 ,job2,job3. Thanks sunitha

6 Answers   CTS,

How and where you used hash file?

0 Answers  

Why do we use link partitioner and link collector in datastage?

0 Answers  

country, state 2 tables r there. in table 1 have cid,cname table2 have sid,sname,cid. i want based on cid which country's having more than 25 states i want to display?

3 Answers   Wipro,

What are the types of jobs we have in datastage?

0 Answers  

What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

0 Answers   IBM,

which dim, fact tables used in bank domain

1 Answers   HSBC, IBM,

source 1123445 I WANT OUTPUT AS DUPLICATES TO TARGET1 LIKE TARGET1 1144 NON-DUPLICATES TO TARGET2 TARGET2 235

6 Answers   US Technology,

For more Data Stage Interview Questions Click Here
Categories