Whatis the difference between View and Materialized View ?

Answers were Sorted based on User's Feedback



Whatis the difference between View and Materialized View ?..

Answer / guest

In view we cannot do DML commands where as it is possible
in Materialized view.

Is This Answer Correct ?    39 Yes 121 No

Post New Answer

More Informatica Interview Questions

In update strategy t/r we had given dd_insert condition & in session we gave delete condition . Then what will happen? mapping will run ?

3 Answers   emc2,


How mapping parameter and variable works

1 Answers  


Do you have knowledge in ralph kimball methodology

1 Answers  


What is a joiner transformation and why it is an active one?

0 Answers  


COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

0 Answers  






How would you copy the content of one repository to another repository?

0 Answers  


Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.

3 Answers   IBM,


what r the transformations that r not involved in mapplet?

8 Answers   Wipro,


What is aggregate cache in aggregator transforamtion?

5 Answers  


Under which circumstances, informatica server creates reject files?

0 Answers   Informatica,


How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

0 Answers  


Hi, As shown below i have repositories under that some folder are there . Between these repositories and folder some thing is there.I want to know what is that? repositories repo1 repo2 repo3 IS_## IS_## IS_## Folder1 Folder2 Folder3 - - - Here i want to what IS_## represents ? Advance Thanks

1 Answers   IBM,


Categories