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
- 7184 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 is a ds designer?
Explain entity, attribute and relationship in datastage?
What are iconv and oconv?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
what is ds administrator used for?
Is possible to create skid in dim,fact tables?
What is data partitioning?
What are the different types of lookups in datastage?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
What are the functionalities of link partitioner?
What is the difference between datastage and datastage tx?
What are the primary usages of datastage tool?
Explain ibm infosphere information server and highlight its main features?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
Can you implement SCD2 using join, transformer and funnel stage?
