Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 5 Answers
- 10222 Views
- I also Faced
- E-Mail Answers
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
draw informatica architecture 8.6 ?
tell me 5 session failure in real time how can you solve that in your project?
Suppose we do not group by on any ports of the aggregator what will be the output?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
How can repository reports be accessed without sql or other transformations?
What is the advantage of informatica?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What is the difference between Active and Passive transformation?
What are the transformations that are not supported in mapplet?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
r u done any partitions in ur project?
Does an informatica transformation support only aggregate expressions?
can we override a native sql query within informatica? Where do we do it?
What is the benefit of partitioning a session?
