Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / abhinaw prakash
When we issue Select * from View it'll fetch the data from
the Base table were as with Materialized view when we issue
select * from Materialized view it ll fetch the data from
the materialized view.
Also with using materialized view we can escape the run time
joins that it ll have to do when retrieving for a query.
Also with View you cannot schedule it for refresh but with
MV we can schedule it for Refresh
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is standalone command task?
What is rank transformation in informatica
Partition, what happens if the specified key range is shorter and longer
What does reusable transformation mean?
What does refresh system mean, and what are its distinctive choice?
What is joiner transformation?
Define the various join types of joiner transformation?
Target increases every day even though no new record was inserted
What is the use of code page?
How many number of sessions can one group in batches?
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?
How we can create indexes after completing the loan process?
What are the uses of etl tools?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
