I have source like col1,col2,col3,col4 and the values are like
3,6,1,7
1,5,3,8
2,1,5,6

i want the output like
3,6,7
5,3,8
2,5,6

How we will achieve in this scenario in informatica level.
Please help me..

Thanks in advance..




Answer Posted / davan

Its not a proper ???.there is no logic in ????.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an aggregator transformation?

610


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

869


What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

7666


What is a standalone command task?

643


What is main use of mapplet?

650






What is the difference between stop and abort in informatica

652


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.

2291


Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

1841


how we can load rejected record's at run time?(not through bad files)

1904


Whats there in global repository

1258


Scheduling properties,whats the default (sequential)

1453


Name the different lookup cache(s)?

696


How to use pmcmd utility command?

574


Explain the mapping variable usage example in informatica

626


tell me 5 session failure in real time how can you solve that in your project?

1625