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
Which is the t/r that builts only single cache memory?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Different sorts of metadata that stores in the storage facility?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Explain incremental aggregation in informatica
Could you explain what is enterprise data warehouse?
In how many ways we can create ports?
Write the unconnected lookup syntax?
Define pmcmd command?
How to call shell scripts from informatica?
hi real timers . iam waiting for ur reply regarding ETL TESTING
what is the -ve test case in your project.
in reporting we add some new objects,how we get the count of the newly added objects to the report
In informatics server which files are created during the session rums?
What is a repository? And how to add it in an informatica client?