DATA WAREHOUSE INTERVIEW QUESTIONS AND ANSWERS

DATA WAREHOUSE MOST ASKED Job Interview Questions. Read DATA WAREHOUSE Interview Questions and Answers for Experienced, Freshers PDF Download.

Read DATA WAREHOUSE Questions and Answers for Interview

What is a source qualifier?View Answer
What is data warehouse architecture?View Answer
What are data validation strategies for data mart validation after loading process?View Answer
What is Virtual Data Warehousing?View Answer
What is a View?View Answer
Can objects of the same Schema reside in different table spaces?View Answer
What are the steps involved in Database Startup?View Answer
What is the data type of the surrogate key?View Answer
What is data analysis? Where it will be used?View Answer
What are the data types present in BO? What happens if we implement view in the designer n report?View Answer
What is the difference between metadata and data dictionary?View Answer
What is an Extent?View Answer
Can a Table space hold objects from different Schemes?View Answer
Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the table space?View Answer
What are the steps to build the data warehouse?View Answer
What are data modeling and data mining? Where it will be used?View Answer
What is surrogate key? Where we use it? Explain with examples.View Answer
What is the difference between mapping parameter & mapping variable in data warehousing?View Answer
What is an Index?View Answer
Can a View based on another View?View Answer
What is On-line Redo Log?View Answer
What is the advantages data mining over traditional approaches?View Answer
What is “method/1??View Answer
What is a linked cube?View Answer
Explain the advantages of RAID 1, 1/0, and 5. what type of RAID setup would you put your TX logs.View Answer
What is an Integrity Constrains?View Answer
What is a full backup?View Answer
What is Log Switch?View Answer
What is the difference between view and materialized view?View Answer
After the generation of a report to whom we have to deploy or what we do after the completion of a report?View Answer
What are the Characteristics of Data Files?View Answer
What are Clusters?View Answer
What is Mirrored on-line Redo Log?View Answer
How can we run the graph? What is the procedure for that? How can we schedule the graph in UNIX?View Answer
What is Dimensional Modelling?View Answer
What is the main difference between Inmon and Kimball philosophies of data warehousing?View Answer
After the complete generation of a report who will test the report and who will analyze it?View Answer
What is Rollback Segment?View Answer
What are the different types of Segments?View Answer
What is Partial Backup?View Answer
What is a real-time data warehouse? How is it different from near to real-time data warehouse?View Answer
What are the difference between Snow flake and Star Schema? What are situations where Snow flake Schema is better than Star Schema to use and when the opposite is true?View Answer
What is junk dimension? What is the difference between junk dimension and degenerated dimension?View Answer
Can you pass sql queries in filter transformation?View Answer
What is a Table space?View Answer
Explain the relationship among Database, Table space and Data file?View Answer
What is Restricted Mode of Instance Startup?View Answer
What is difference between drill & scope of analysis?View Answer
What is a cube in data warehousing concept?View Answer
Why fact table is in normal form?View Answer
Where the Data cube technology is used?View Answer
What is Database Link?View Answer
What is an Index Segment?View Answer
What is Archived Redo Log?View Answer
I have two Universes created by two difference database can we join them in Designer & Report level? HowView Answer
What are the differences between star and snowflake schema?View Answer
What is Difference between E-R Modeling and Dimensional Modeling?View Answer
How can you implement many relations in star schema model?View Answer
What is a Private Synonyms?View Answer
What is a Redo Log?View Answer
What are the steps involved in Database Shutdown?View Answer
For faster process, what we will do with the Universe?View Answer
What are Data Marts?View Answer
What is conformed fact?View Answer
What is critical column?View Answer
What is a Hash Cluster?View Answer
What are the types of Synonyms?View Answer
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode?View Answer
What is type 2 version dimension?View Answer
What are Fact, Dimension, and Measure?View Answer
What are the methodologies of Data Warehousing?View Answer
What is the main difference between star and snowflake star schema? Which one is better and why?View Answer
Describe Referential Integrity?View Answer
What are the Referential actions supported by FOREIGN KEY integrity constraint?View Answer
What are the different modes of mounting a Database with the Parallel Server?View Answer
What is unit testing?View Answer
What are the different types of data warehousing?View Answer
What is BUS Schema?View Answer
What is the difference between dependent data warehouse and independent data warehouse?View Answer
What is schema?View Answer
Do you View contain Data?View Answer
Can Full Backup be performed when the database is open?View Answer
What is Informatica Architecture?View Answer
What do you mean by static and local variable?View Answer
What is Data warehousing Hierarchy?View Answer
Which technology should be used for interactive data querying across multiple dimensions for a decision making for a DW?View Answer
What is Table?View Answer
What is the use of Control File?View Answer
What are the steps involved in Instance Recovery?View Answer