I have the input file as
col1 col2 col3
3 2 1
7 6 8
I should get the output as
col1 col2 col3
1 2 3
6 7 8 ....What is the logic to get this? Is there any
transformation which sorts row wise ? If not how to sort
the incoming records row wise?
Answer Posted / vidyasagar
u can try this:)
src>> Normalizer>> sorter by asc>> Normalizer>> TgT
Regards:
Vidyasagar
Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Under which circumstances, informatica server creates reject files?
draw informatica architecture 8.6 ?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Different sorts of metadata that stores in the storage facility?
How do you set a varible in incremental aggregation
What is primary and backup node?
What are batches?
What is the commit type if you have a transaction control transformation in the mapping?
What do you mean by enterprise data warehousing?
write a query to retrieve the latest records from the table sorted by version(scd)
How to extract sap data using informatica?
Define joiner transformation?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Different qualification between a related rotate toward the sky and isolates look upward?