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
- 7808 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
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
How do you convert single row from source into three rows into target?
Why do we need informatica?
How does a sorter cache works?
What is the surrogate key?
What are junk dimensions?
Explain the use of aggregator cache file?
can u give example for factless fact table
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What are the components of Informatica? And what is the purpose of each?
How to create the source and target database connections in server manager?
What are the settings that you use to configure the joiner transformation?
How can a transformation be made reusable?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Where are the source flat files kept before running the session?
