Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 13176 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
Explain datastage architecture?
How to perform incremental load in datastage?
Can you explain link buffering?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
How do you remove duplicate values in datastage?
What is staging variable?
What are the various kinds of the hash file?
Can you explain engine tier in information server?
What are orabulk and bcp stages?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
How to reverse the string using SQL?
How do you generate sequence number in datastage?
What is meta stage?
What are sequencers?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
