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
- 10037 Views
- I also Faced
- E-Mail Answers
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
where to store informatica rejected data? How to extract the informatica rejected data?
What is event and what are the tasks related to it?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
How to generate sequence numbers without using the sequence generator transformation?
Explain the informatica workflow?
Explain lookup transformation in informatica
What is status code in informatica?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What all are steps in up gradation of Informatica server?
What is a node in Informatica?
What are the different types of olap? Give an example?
Can informatica load heterogeneous targets from heterogeneous sources?
What is a joiner transformation?
Is it possible to use a client with different version than that of its Informatica server?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
