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
- 10022 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 the function of look up transformation?
Explian the Process of deployment groups in informatica
Explain the types of transformations?
What is meant by incremental aggregation?
During the running session, output files are created by informatica server. Enlist few of them.
Reusable transformation and shortcut differences
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
Implementation methodology
What is the different lookup cache(s)?
Define enterprise data warehousing?
Mention few advantages of router transformation over filter transformation.
How is union transformation utilized?
What are the different types of olap? Give an example?
What is informatica? Why do we need it?
How can one identify whether mapping is correct or not without connecting session?
