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 / 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 the format of informatica objects in a repository?
What are the performance considerations when working with aggregator transformation?
Explain the mapping variable usage example in informatica
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
What is a sorter transformation?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What is Cognos script editor?
Can we create a Integration service without a Repository service and vice versa?
Is it possible to revert a global repository to local one and why?
Write the program through which the records can be updated?
How do you promote a non-reusable transformation to reusable transformation?
What is the status code in stored procedure transformation?
What is parallel processing in informatica?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Explain Dataware house architecture .how data flow from intial to end?