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


Please Help Members By Posting Answers For Below Questions

What are the issues you have faced in your project? How did you overcome those issues?

1910


TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1463


In how many ways we can create ports?

700


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

2278


can we override a native sql query within informatica? Where do we do it? How do we do it?

597






What are the types of caches in lookup?

568


Explain target update override in informatica

631


Explain joiner transformation in informatica

666


what are factless facts? And in which scenario will you use such kinds of fact tables.

1315


What is repository manager?

534


How to Create a folder using pmrep command?

623


What is dimensional table? Explain the different dimensions.

658


What is a mapplet/worklet in informatica?

687


How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

695


What are the new features of Power Center 5.0?

1234