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
How can we delete duplicate rows from flat files?
What is a predefined event?
what is the hint? how to use it to reduce the query processing in program?
What is xml source qualifier transformation in informatica?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Explain the difference between a data warehouse and a data mart?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is a node in Informatica?
What do you understand by term role-playing dimension?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
During the running session, output files are created by informatica server. Enlist few of them.
How to use procedural logic inside infromatica?
What are the different types of transformation available in informatica.
Describe the impact of several join conditions and join order in a joiner transformation?
Different qualification between a related rotate toward the sky and isolates look upward?