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 / ankit kansal
You have to use an expression transformation and have two create three variables and output ports and have to write IIF() conditions for all three columns to achieve your desired order.
http://deepinopensource.blogspot.in/
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can we use mapping variables in informatica? Where do we use them?
How many dimensions are there in informatica?
What is meant by query override?
what is the size of u r source(like file or table)?
What is dimensional table? Explain the different dimensions.
can u any challenge your project?
What is status code in informatica?
How can we update a record in the target table without using update strategy?
can u give example for factless fact table
What are the types of caches in lookup? Explain them.
Explain joiner transformation in informatica
Separate from a database, an information bazaar, and an information stockroom?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Explain pmcmd command usage in informatica
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.