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
- 8464 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
What is native users?
How can we handle two sessions in informatica?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What are the steps involved in the migration from older version to newer version of Informatica Server?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
How many number of sessions can one group in batches?
How many input parameters can exist in an unconnected lookup?
What is data movement mode in Informatica and difference between them?
In warehouses how many schemas are there?
What is a dimensional model?
How to generate or load values in to the target table based on a column value using informatica etl tool.
Can we create a Integration service without a Repository service and vice versa?
What is joiner change?
How to elaborate tracing level?
