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
How to improve the performance of a session using sorter transformation?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Explain the etl program with few examples.
Explain informatica architecture - version 8 / 9
what is mean by complex business rule ?
What are data-driven sessions?
What is the scenario which compels informatica server to reject files?
Which means the first record should come as last record and last record should come as first record and load into the target file?
Does an informatica transformation support only aggregate expressions?
What is a repository? And how to add it in an informatica client?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
expain about the tune parameters?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What are the types of schemas we have in data warehouse and what are the difference between them?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records