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 decode in informatica?
What happens when a session fails and you click on recover?
What are the different types of transformation available in informatica.
lookup transformation with screenshots
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What is a difference between complete, stop and abort?
Explain the difference between mapping parameter and mapping variable?
Write the unconnected lookup syntax?
Tell me about Propagate functions in informatica
Explain what is informatica metadata and where is it stored?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
can you please explain me pre session and post session options?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What is deployment group?