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 / raja
There is no logic for this.You should try to be smart by
asking the useless question.try to ask some question which
will be useful for others.
| Is This Answer Correct ? | 11 Yes | 2 No |
Post New Answer View All Answers
How can we delete duplicate rows from flat files?
What is a sorter transformation?
What is different between the data warehouse and data mart?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
Explain about Informatica server process that how it works relates to mapping variables?
Can we get 1st record through Informatica(without sequence number).
Explain the aggregator transformation?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
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.
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?
What are the different clients of powercenter?
Explain the different lookup methods used in informatica?
my source is junk data how will u remove that junk data by using unix please any one replay me
How can a transformation be made reusable?