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
Describe data concatenation?
Which are the different editions of informatica powercenter that are available?
where to store informatica rejected data? How to extract the informatica rejected data?
COM components can be used in Informatica
What is data transformation manager process?
What is the different lookup cache(s)?
What is a mapplet/worklet in informatica?
What is aggregate cache in aggregator transformation?
What is a router transformation?
How to delete duplicate row using informatica?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
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?
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
Different sorts of metadata that stores in the storage facility?
Difference between Target-based loading and constraint-based loading?