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.
- 6 Answers
- 10899 Views
- Teradata, I also Faced
- E-Mail Answers
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
How you Implemented SCD Type 1 & Type 2 in your project?
Describe the architecture of datastage?
what is the custome stage in datastage? how can we impliment that one? plz tell me
what is 'reconsideration error' and how can i respond to this error and how to debug this
What are the main features of datastage?
Differentiate between odbc and drs stage?
What is the use of datastage designer?
How to perform incremental load in datastage?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
What are the stages in datastage?
What is difference between server jobs & parallel jobs?
How we can covert server job to a parallel job?
What is the precedence of stage variables,derivations, and constraints?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
How a source file is populated?
