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
- 9156 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 to create a non-reusable instance of reusable transformations?
How many types of sessions are there in informatica.please explain them?
what is the -ve test case in your project.
Write the advantages of partitioning a session?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What do you mean by enterprise data warehousing?
What is the use of code page?
Explain the etl program with few examples.
What is a grid in Informatica?
What are the uses of etl tools?
How we can create indexes after completing the loan process?
Explain lookup transformation source types in informatica
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Explain load alternative records / rows into multiple targets - informatica
What is the way to execute pl/sql script using informatica mapping?
