What are materialized views & where do we use them?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More ETL Interview Questions

what is an ETL or ETT? And what are the different types?

0 Answers  


how do u automate Extraction process?

1 Answers  


What do you understand by active and passive transformations?

0 Answers  


what is pmrep command?

0 Answers  


Hi, Urgent recruitment in CTS for informatica ETL .Experience 3 to 10 years.

3 Answers   TCS,






How to load Session Statistics (Workflow name, TgtRows, Rejected Rows, SessStartTime,SessEndTime..)into a database table ?? Another Question: I want to pass values from oracle table or Flat file in Mapping parameter/Variable.. What is the method for that..Please provide me the solution step by step

1 Answers  


What are the types of data warehouse applications and what is the difference between data mining and data warehousing?

0 Answers  


what is the advantage of persistent cache? when it should be used?

2 Answers  


what are the different Reporting and ETL tools available in the market?

3 Answers  


Can we parametrize the values of IN statement. Ex. Inside parameter file: Parameter='A','B','C' Inside Code: IN (INPUT_CHARACTER, $$Parameter)

2 Answers   Cognizant, IBM,


Can u access a repository created in previous version of Informatica?

1 Answers   DELL,


we hava more than 1000 records. i have to select first 5 record, last 5 record and 5 records from middle of the source. how can i do in oracle as well as in informetica??

4 Answers  


Categories