Data Warehouse General Interview Questions
Questions Answers Views Company eMail

What is source qualifier?

2 8899

Difference between DSS & OLTP?

IBM,

6 49722

Explain grouped cross tab?

2299

Hierarchy of DWH?

Accenture, EDS, IBM, iFlex, TCS,

2 17878

How many repositories can we create in Informatica?

Informatica,

14 25721

What is surrogate key?

IBM, Informatica,

5 20750

What is difference between Mapplet and reusable transformation?

UST,

3 6077

What is aggregate awareness?

2 6891

Explain reference cursor?

1816

What are parallel querys and query hints?

1894

DWH architecture?

6 16892

What are cursors?

4 7783

Advantages of de normalized data?

2 10496

What is operational data source (ODS)?

2 9606

What is meta data and system catalog?

1971


Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Could any one explain me how to create cascading prompts?

617


Start a batches with in a batch?

655


How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?

658


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

636


Explain bus schema?

640






What are components of report studio?

664


What is a hash cluster?

648


Difference between cold fusion 5 and cold fusion mx 6?

702


What is vdl (view definition language) explain?

749


Explain meta data?

662


how much memory space occupied real time project (roughly)?

1928


What is a linked cube?

640


Explain a relation schema and a relation?

720


What is a view as it relates to system modeling?

689


Explain what is the data type of the surrogate key?

692