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
- 8524 Views
- I also Faced
- E-Mail Answers
Answer Posted / nithyanandan
use normaliser transformation for this question
ur source contain 3-column ,
wihile taking to target there is should not be primaty key
colum in ur target table.
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
How do you update the records with or without using update strategy?
What is workflow? What are the components of workflow manager?
When do you use sql override in a lookup transformation?
Partition, what happens if the specified key range is shorter and longer
What is joiner change?
What are the mapping parameters and mapping variables?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What does command task mean?
Write the advantages of partitioning a session?
Mention few advantages of router transformation over filter transformation.
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What are the guidelines to be followed while using union transformation?
What are the settings that you use to configure the joiner transformation?
Explain the types of transformations?
State the limitations where we cannot use joiner in the mapping pipeline?
