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
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?
Informatica Checkpoints
Which version configuration tool used in ur project?
Explain the tuning lookup transformation - informatica
What is the difference between a repository server and a powerhouse?
How many ways are there to do 'remove duplicate records in informatica'?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is workflow manager?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Explain load alternative records / rows into multiple targets - informatica
What is the benefit of partitioning a session?
How many input parameters can exist in an unconnected lookup?
Explain your project of banking domian.
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
