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 / vishnu
there is no need to use specific transformation to do
this...
Simply connect the ports like.....Col1---
>col3,col2.....>col2 and col3......>col1 then u wil get the
result...any issues let me know
| Is This Answer Correct ? | 5 Yes | 4 No |
Post New Answer View All Answers
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Explain Dataware house architecture .how data flow from intial to end?
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
What are the reusable transformations?
What do you mean by blocking transformation?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
what is SDLC way of code development?
Explain incremental aggregation in informatica
What is aggregate cache in aggregator transformation?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
what are the Methods For Creating Reusable Transformations?
Can we create a Integration service without a Repository service and vice versa?
What is the difference between writing a joiner query in ANSI style and THETA style?
write a query to retrieve the latest records from the table sorted by version(scd)
How to extract sap data using informatica?