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
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 different layers in the information server architecture?
What are the types of containers and how to create them?
Distinguish between informatica & datastage. Which one would you choose and why?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
Can we use target hash file as a lookup ?
What is the difference between validated and compiled in the datastage?
CHANGE CAPTURE
AGGREGATOR default datatype
What are the difference types of stages?
Where do you see different stages in the designer?
How many types of sorting methods are available in datastage?
What is data partitioning?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
What is a datastage job?