HI Zer0 YOUR SOLUTION PERFECTLY WORKING GREAT BUDDY

get me the resultant
input:- 1 x,y,z output:- 1 x
2 a,b 1 y
3 c 1 z
2 a
2 b
3 c

Question Posted / kondeti srinivas

Answer Posted / kondeti srinivas

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2708

What is decode in static cache?

1154

Can we override a native sql query within informatica?

1025

Explain the pipeline partition with real time example?

1123

Explain in detail scd type 2 through mapping.

1028

Design time, run time. If you don't create parameter what will happen

1827

What is xml source qualifier transformation in informatica?

1206

can anyone explain me about retail domain project in informatica?

7929

Which means the first record should come as last record and last record should come as first record and load into the target file?

1059

What are the types of lookup transformation?

1059

How to do unit testing in informatica?

1161

Explain what is informatica metadata and where is it stored?

1035

Design a mapping to load a target table with the following values from the above source?

1327

Quickly characterize reusable change?

1092

have u done any performance tuning? how u ll do?

2277