Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between view and materialised view?
- 6 Answers
- 14371 Views
- I also Faced
- E-Mail Answers
Answer Posted / yaseen
Rowid of view and table is same
Rowid of M.view and table is different
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Design a mapping to load the cumulative sum of salaries of employees into target table?
What is the function of look up transformation?
What is the use of transformation?
How to do unit testing in informatica?
Mention a few design and development best practices for informatica?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Can we get 1st record through Informatica(without sequence number).
What's the layout of parameter file (what does a parameter file contain?)?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
During the running session, output files are created by informatica server. Enlist few of them.
Explain the scenario which compels informatica server to reject files?
How to extract sap data using informatica? What is abap? What are idocs?
can we override a native sql query within informatica? Where do we do it? How do we do it?
Explain sessions. Explain how batches are used to combine executions?
where to store informatica rejected data? How to extract the informatica rejected data?
