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 / pavana
we can sort row wise by using expression transformation .
But the logic to sort must be implemented.by having few
variable ports...
Let me know if there is any other way to sort row wise.
Mr Raja
u can be quite if u dont know the answers. At least others
will answer.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
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 is the function of look up transformation?
What is DR strategy for Informatica project?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Explain how many types of dimensions are available in informatica?
What is dynamic cache?
What is informatica powercenter repository?
How many types of sessions are there in informatica.please explain them?
Repository user profiles
What is target designer and target load order?
What are connected or unconnected transformations?
What is the difference between STOP and ABORT options in Workflow Monitor?
EXL informatica Questions
What is a router transformation?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.