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
- 10269 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
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What is an active transformation?
Implementation methodology
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What are multi-group transformations?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
How many types of sessions are there in informatica.please explain them?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What could be the possible resons of locks by user?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
In informatica workflow manager, how many repositories can be created?
Briefly explain the aggregator transformation?
