What is source qualifier?2 7066
What is aggregate awareness?2 5578
DWH architecture?6 13820
What are cursors?4 5889
Advantages of de normalized data?2 9283
What is operational data source (ODS)?2 8063
What is a staging area? Do we need it? What is the purpose of a staging area?
How to join 3 database like flat file, oracle, db2 in informatrica?
Explain multivalued dependency?
List any five applications of data warehouse.
Can we start and stop single session in concurent bstch?
What does level of granularity of a fact table signify?
What is batch processing?
Do you view contain data?
Compare aggregates and data marts
Explain what is the difference between olap and datawarehosue?
Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.
Explain what are the methodologies of data warehousing?
Explain functional dependency?
How to generate the cubes in framework manager?
How to calculate fact table granularity?