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
- 10967 Views
- Teradata, I also Faced
- E-Mail Answers
Answer Posted / prasad
MadhavaReddy, who gave logic that is correct.
I tried, got exact result.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the areas of application?
What is a merge in datastage?
What are the partitioning techniques available in link partitioner?
How complex jobs are implemented in datstage to improve performance?
root tree will find which is server job and which is parallel job?
What a datastage macro?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
options available in sequence job to run,validate?
project Steps,hits, Project level HArd things,Solved methods?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
What is the purpose of pivot stage?
Can you explain link buffering?
What are the difference types of stages?
What are the different options associated with dsjob command?
What are iconv and oconv?
