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
- 7458 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 processing stages?
Difference between data warehousing and olap?
What is usage analysis in datastage?
What are the steps needed to create a simple basic datastage job?
what is use of SDR function?
What is the difference between Datastage 7.5 and 7.0?
Define oconv () and iconv () functions in datastage?
options available in sequence job to run,validate?
What steps should be taken to improve Datastage jobs?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
In Datastage, how you can fix the truncated data error?
how to implement scd2 in datastage 7.5 with lookup stage
Differentiate between odbc and drs stage?
what is ds administrator used for?
How you Implemented SCD Type 1 & Type 2 in your project?
