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
- 7922 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 we can load rejected record's at run time?(not through bad files)
Explain load alternative records / rows into multiple targets - informatica
How to handle decimal places while importing a flatfile into informatica?
Enlist the various types of transformations.
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Where do we use mapping variables in informatica?
What are the different versions of informatica?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Can we get 1st record through Informatica(without sequence number).
How can we create index after completion of load process?
How can you generate reports in informatica?
What you know about transaction control transformation?
What is a repository? And how to add it in an informatica client?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
Explain lookup transformation in informatica
