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
- 6661 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
Slowly changing dimensions, types and where will you use them
What is substr in informatica?
What are the prerequisite tasks to achieve the session partition?
What are the different options available for update strategy?
tell me the rules and responsblites in our project(my project is development)
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
How to convert multiple rows to single row (multiple columns) in informatica
Enlist the advantages of informatica.
Explain pushdown optimization and types in informatica
What are the different types of repositories created using informatica?
What is parallel processing in informatica?
What is the benefit of session partitioning?
What are the tasks that source qualifier perform?
How many dimensions are there in informatica?
What are the limitations of joiner transformation?
