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
- 13005 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
What is the difference between datastage and datastage tx?
what is flow of project?
why do u need the IOS upgradation in a FC switch
What are the functionalities of link partitioner?
What can we do with datastage director?
What are the steps needed to create a simple basic datastage job?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
Explain ibm infosphere information server and highlight its main features?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
Why do we use exception activity in Datastage?
What is usage analysis in datastage?
Difference between sequential file and data set?
Can you explain kafka connector?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
Why do you need stage variables?
