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
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
How do you set a varible in incremental aggregation
Explain your project of banking domian.
The question was on time stamp. what is the difference between HH and HH24 when to use when.
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Briefly define reusable transformation?
How do you take back up of repository?
Mention a few design and development best practices for informatica?
can you please explain me pre session and post session options?
Write the different tools in the workflow manager?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
How would you join a node to the already existing domain?
What is meant by lookup transformation?
what is informatica metadata?
Write the unconnected lookup syntax?