source table col1 col2 101 1-a 102 1-a,2-ab 103 1-a,2-ab,3-abc

scenario

Question Posted / prasad_bestha

Answer Posted / prasad_bestha

source table

col1 col2
101 1-a
102 1-a,2-ab
103 1-a,2-ab,3-abc

target table
col1 col2 col3
1 101 a
2 102 a
3 102 ab
4 103 a
5 103 ab
6 103 abc

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what are the deliverables?in your project?

2085

Global and Local shortcuts. Advantages.

1964

What is exclusive and normal mode for repository services?

1063

what is SDLC way of code development?

1971

What is difference between a gateway node and worker node?

1069

explain about unit testing? in real time?

2140

What is lookup transformation?

1004

Slowly changing dimensions, types and where will you use them

1656

define galaxy repository in informatica

2157

What is workflow? What are the components of workflow manager?

1122

How to go to the older version for a mapping?

1031

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2061

What is a surrogate key?

1019

How to start a workflow using pmcmd command?

1178

How to update source definition?

1032