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

Briefly define a session task?

805


Which transformation is needed while using the Cobol sources as source definitions?

936


Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

6885


How do you manage the Parameter files while migrating your data from one environment to another environment?

770


Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1792


What is pmcmd command?

876


What is the function of look up transformation?

865


Can informatica load heterogeneous targets from heterogeneous sources?

942


Under what conditions selecting sorted input in aggregator will still not boost session performance?

832


What is a code page?

910


What are the tasks that can be performed using sq?

829


What do you mean by channel change?

756


can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3619


How do you update the records with or without using update strategy?

881


What is event and what are the tasks related to it?

828