Interested to Buy Any Domain ? << Click Here >> for more details...
The Source coloumns are A,B,C with data row1- 10,20,30 row2-
40,50,60 row3-70,80,90 and so on. In the target I want one
coloumn with the following data, Coloumn-X, row1-10,row2-
20,row3-30,row4-40,row5-50 and so on. How to achieve this?
- 3 Answers
- 7794 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / babu
Hi All,
By using Normalizer Transformation we will achive this.
Mapping:
========
Src==>SQ==>Nrm(Normalizer)==>Srt(sorter)==>Trg
Nrm:Column(Occerence 3)
Column1 (inputport)
Column2 (inpuport)
Column3 (inputport)
Column (outputport)===> Srt ==>Trg
| Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
How do you load alternate records into different tables through mapping flow?
How to join three sources using joiner?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What are the advantages of using informatica as an etl tool over teradata?
What is a connected transformation?
Please let me know how to make Data masking in informatica..
What is pmcmd command?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What is the scenario which compels informatica server to reject files?
How can we use mapping variables in informatica? Where do we use them?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What are the popular informatica products?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
