Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
No Answer is Posted For this Question
Be the First to Post Answer
If your client approaches you and says that he wants to create a Datawarehouse, and provides just the info regarding his source systems. What are all the neccessary actions one is supposed to take/understand and get back with a comprehensive document which convinces the client to proceed with the DW initiative. What are all the documents we need to provide the client?
What is the difference between mapping parameter & mapping variable in data warehousing?
What are the different ways to represent the loading of dimension tables?
What are situations where snow flake schema is better than star schema to use and when the opposite is true?
how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause
What is the very basic difference between data warehouse and operational databases?
What are session timeout and application timeout?
How to create different types of templates?
What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?
Compare cold fusion with other programming languages?
Is union transormation is active transformation?
What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?