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 source qualifier?

2 7066

Difference between DSS & OLTP?

IBM,

6 42360

Explain grouped cross tab?

1820

Hierarchy of DWH?

Accenture, EDS, IBM, iFlex, TCS,

2 15457

How many repositories can we create in Informatica?

Informatica,

14 19813

What is surrogate key?

IBM, Informatica,

5 18034

What is difference between Mapplet and reusable transformation?

UST,

3 4144

What is aggregate awareness?

2 5578

Explain reference cursor?

1346

What are parallel querys and query hints?

1434

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 meta data and system catalog?

1510


Post New Data Warehouse General Questions






Un-Answered Questions { Data Warehouse General }

What is a staging area? Do we need it? What is the purpose of a staging area?

184


How to join 3 database like flat file, oracle, db2 in informatrica?

203


Explain multivalued dependency?

210


List any five applications of data warehouse.

183


Can we start and stop single session in concurent bstch?

185






What does level of granularity of a fact table signify?

180


What is batch processing?

191


Do you view contain data?

198


Compare aggregates and data marts

1834


Explain what is the difference between olap and datawarehosue?

203


Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.

162


Explain what are the methodologies of data warehousing?

179


Explain functional dependency?

178


How to generate the cubes in framework manager?

198


How to calculate fact table granularity?

190