Hi,
source data is
col1 values are 5,6,7
col2 are 3,2,1
col3 are 8,9,10
and i want to get target as
col1 5,6,7
col2 1,2,3
col3 8,9,10
how to do this one?

Answer Posted / vasu

Benz
if we follow like that , we couldn't get the remains
column's data order,surely that will change.

if u get another ,let me know

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Describe data concatenation?

574


Which are the different editions of informatica powercenter that are available?

558


where to store informatica rejected data? How to extract the informatica rejected data?

607


COM components can be used in Informatica

1875


What is data transformation manager process?

619






What is the different lookup cache(s)?

614


What is a mapplet/worklet in informatica?

692


What is aggregate cache in aggregator transformation?

635


What is a router transformation?

629


How to delete duplicate row using informatica?

611


explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

1706


Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

556


COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1534


Different sorts of metadata that stores in the storage facility?

561


Difference between Target-based loading and constraint-based loading?

553