In a scenario I have col1, col2, col3, under that 1,x,y, and
2,a,b and I want in this form col1, col2 and 1,x and 1,y and
2,a and 2,b, what is the procedure?
Answer Posted / ram
Create normaliser...
derive 2 ports
col_1 occurence=2
col_2 Occurence=2
now you will get four input ports..
col1 -->col_1
col1---> col_1
col2--->col_2
col3--->col_2
connect two output ports from normaliser to Target..
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is sorter transformation?
What is olap (on-line analytical processing?
What is InformaticaPowerCenter?
What are the guidelines to be followed while using union transformation?
How big was your fact table
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
difference between repository database and repository service?
What are the performance considerations when working with aggregator transformation?
What is primary and backup node?
What you know about transaction control transformation?
How would you join a node to the already existing domain?
What is the function of look up transformation?
What does “tail –f” command do and what is its use as an Informatica admin.
According to his methodology what all you need before you build a datawarehouse