Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Data Warehouse General Interview Questions
Questions Answers Views Company eMail

What is an error log table in informatica occurs and how to maintain it in mapping?

401

What is static and local variable?

355

What is the main difference between schema in rdbms and schemas in datawarehouse?

364

What is surrogate key? Where we use it explain with example?

326

Explain can a dimension table contains numeric values?

409

What is crass reference table?

372

What is a fact, dimension, measure?

377

Explain difference between e-r modeling and dimentional modeling?

383

Explain the definition of normalized and denormalized view and what are the differences between them?

350

Explain the definition of normalized and denormalized view?

353

Explain why fact table is in normal form?

386

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

358

Explain dimensional modelling?

363

What is batch processing?

397

What is aggregate fact table?

355


Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

How can you clear the cache?

352


What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

361


Explain what is the metadata extension?

386


Explain how many ways you create ports?

426


What are necessary tasks to install reportnet software?

348






Name a few sectors which use data warehousing?

360


What is difference between query studio and report studio?

364


What are aggregate tables and aggregate fact tables?

350


Explain what is real time data-warehousing?

380


Where the data cube technology is used?

377


How to provide security in frame work manager for a query subject?

329


How to test report in reportnet?

391


Explain what are the different types of data warehousing?

346


What is drill-through?

386


What are the steps involved in designing a fact table?

335