Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 5 Answers
- 9957 Views
- I also Faced
- E-Mail Answers
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
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Mention a few design and development best practices for informatica?
Why is sorter an active transformation?
what is the -ve test case in your project.
What is a filter transformation?
What is powercenter on grid?
Slowly changing dimensions, types and where will you use them
what is the size of u r source(like file or table)?
What is a shortcut and copy in Informatica and how two are different with each other?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What is substr in informatica?
explan ur project architecture?
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.
How can a transformation be made reusable?
What is persistent lookup cache?
