What is the difference between a table and the materialized
view?
Answer Posted / chandra
TABLE: A TABLE IS HAVING ALL THE COLUMS DATA
WHERE AS
MATERILIZED VIEW : HAVING SELECTED COLUMS DATA WHICH R
DEFINED IN VIEW
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What are the issues you have faced in your project? How did you overcome those issues?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
In how many ways we can create ports?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
can we override a native sql query within informatica? Where do we do it? How do we do it?
What are the types of caches in lookup?
Explain target update override in informatica
Explain joiner transformation in informatica
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is repository manager?
How to Create a folder using pmrep command?
What is dimensional table? Explain the different dimensions.
What is a mapplet/worklet in informatica?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are the new features of Power Center 5.0?