Answer Posted / eric yang
De-normalized data can save more space and have better
performance when run a sql for it
| Is This Answer Correct ? | 0 Yes | 21 No |
Post New Answer View All Answers
Explain the pipeline partition with real time example?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
While migrating the data from one environment to another environment how would you manage the connections?
What is decode in informatica?
How do you change a non-reusable transformation to reusable transformation?
What are the guidelines to be followed while using union transformation?
What is the commit type if you have a transaction control transformation in the mapping?
Write the unconnected lookup syntax and how to return more than one column.
What is main use of mapplet?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
During the running session, output files are created by informatica server. Enlist few of them.
How can we use batches?
What is a joiner transformation and why it is an active one?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What are the different ways to implement parallel processing in informatica?