Interested to Buy Any Domain ? << Click Here >> for more details...
I/P
---
ID Value
1 AB
2 ABC
3 ADE
4 A
O/p
---
ID Value
1 A
1 B
2 A
2 B
2 C
3 A
3 D
3 E
4 A
- 3 Answers
- 7347 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / upputuri.vinod
first of all we have to split the value into individual char
value(1,1) v(2,2) v(3,3)
c1 c2 c1 c2 c3 c4
1 AB 1 A B
2 ABC---> 2 A B c----> pivot--->o/p
3 ADE 3 A D E
4 A 4 A
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
What are the components of datastage?
What are the different plug-ins stages used in your projects?
What are stage variables and constants?
Differentiate between Join, Merge and Lookup stage?
Name the command line functions to import and export the DS jobs?
What is active and passive stage?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
Where the datastage stored his repository?
Can we use target hash file as a lookup ?
What is quality stage?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What is use Array size in datastage
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
Describe the main features of datastage?
What are the enhancements made in datastage 7.5 compare with 7.0?
