Data Warehouse General Interview Questions
Questions Answers Views Company eMail

What is source qualifier?

2 6652

Difference between DSS & OLTP?

IBM,

6 39969

Explain grouped cross tab?

1663




Hierarchy of DWH?

Accenture, iFlex, IBM, EDS, TCS,

2 14925

How many repositories can we create in Informatica?

Informatica,

14 18324

What is surrogate key?

IBM, Informatica,

5 17176

What is difference between Mapplet and reusable transformation?

UST,

3 3620

What is aggregate awareness?

2 5258




Explain reference cursor?

1205

What are parallel querys and query hints?

1296

DWH architecture?

6 13108

What are cursors?

4 5376

Advantages of de normalized data?

2 8929

What is operational data source (ODS)?

2 7652

What is meta data and system catalog?

1339


Post New Data Warehouse General Questions






Un-Answered Questions { Data Warehouse General }

How can we run the graph? How can we schedule the graph in unix?

61


Explain difference between data ware house & data mart?

55


Explain ddl (data definition language)?

58


How can you communicate with web server (apache or iis) from coldfusion?

54


What is the limit to the number of sources and targets you can have in a mapping?

57






What are situations where snow flake schema is better than star schema to use and when the opposite is true?

51


How can you clear the cache?

55


What is the difference between connected and unconnected stored procedures?

59


Explain what is the main difference between inmon and kimball philosophies of data warehousing?

61


Explain multivalued dependency?

69


What is the difference between aggregate table and materialized view?

54


What is a general purpose scheduling tool?

56


What is vldb(very large databases)?

59


What are the differences between star and snowflake schema?

60


Hi, i want to do certification in datawarehouse?? which certification is best in current trend?? pls mention the cost also if u can....

1395