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

Hi,
I have 3 records,
1 Srini
1 vasa
2 reddy

now i want o/p like this
1 Srinivasa
2 reddy

could u please help in this

Thanks in advance.

Question Posted / madhavareddy

Answer Posted / madhavareddy

seqstage->sortstage->transformerstage->removedupicatestage->targetdataset

sortstage->put chagekeycolum=true

transformer -> stagevariable->sv1 if change key colum =1 then in.column else sv1::in.column

in derivation colum give ->sv1

then in remove duplicate stage keep last record option

then you will get desired output

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is aggtorec restructure operator?

732

Have you used Unstructured data?

841

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

689

What are the functionalities of link collector?

631

How we can covert server job to a parallel job?

601




describe the Steps to confiure a Qlogic switch

1944

What is use Array size in datastage

1313

Differentiate between datastage and informatica?

731

How to RD using transformer?

868

Define APT_CONFIG in Datastage?

669

What is the differentiate between data file and descriptor file?

871

Distinguish between informatica & datastage. Which one would you choose and why?

592

What are sequencers?

618

What are the important features of datastage?

623

How to reverse the string using SQL?

898