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
- 7645 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
Differences between version 7.x and 8.x.
Difference between Target-based loading and constraint-based loading?
What are the types of caches in lookup?
Explain constraint based loading in informatica
Have you worked with/created Parameter file
What are the types of data warehouses?
what is the size of u r source(like file or table)?
What is an expression transformation in informatica?
How to use procedural logic inside infromatica?
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,
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Explain scd type 3 through mapping.
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
What is informatica powercenter repository?
How to delete duplicate row using informatica?
