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 does cheating measurement mean?
Is it possible to create multiple domains on a single Informatica server?
What is the use of an aggregator cache file?
Explain target update override in informatica
Implementation methodology
How do you load unique records into one target table and duplicate records into a different target table?
What are the popular informatica products?
How to load a Dimension ? and how to load a fact table?
What is workflow manager?
What is source qualifier transformation in informatica?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What are the informatica performance improvement tips
What are the new features of informatica 9.x in developer level?
list out all the transformations which use cache?