What is data analytics in simple terms?
What is the difference between static cache and dynamic cache?
Which are the olap tools available that are supported by oracle?
Explain what is the difference between powerplay transformer and power play reports?
Explain me what are data marts?
5.Explain ODS ?
What is real-time datawarehousing?
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
Explain me what is vldb?
how do you use commit frequencies? how does it affect loading performance?
What needs to be done when the database is shutdown?
Explain why dimenstion tables are denormalized in nature?
Explain how to generate iqd file from framework manager?