Data Warehouse General Interview Questions
Questions Answers Views Company eMail

What is source qualifier?

1 4467

Difference between DSS & OLTP?

IBM,

5 24898

Explain grouped cross tab?

1190

Hierarchy of DWH?

Accenture, iFlex, IBM, EDS, TCS,

2 11554

How many repositories can we create in Informatica?

Informatica,

14 13257

What is surrogate key?

IBM,

5 12362

What is difference between Mapplet and reusable transformation?

UST,

3 1604

What is aggregate awareness?

2 3584

Explain reference cursor?

773

What are parallel querys and query hints?

845

DWH architecture?

6 9955

What are cursors?

4 3832

Advantages of de normalized data?

2 7101

What is operational data source (ODS)?

2 5407

What is meta data and system catalog?

784


Post New Data Warehouse General Questions


Un-Answered Questions { Data Warehouse General }

What is difference macros and prompts?

716


Explain reference cursor?

773


why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.

121


Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.

563


How are models actually derived?

603


Explain Association algorithm in Data mining?

573


What are different deliverables according to phases?

1857


what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.

584


hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit

638


Compare aggregates and data marts

1177


What are algorithms provided by Microsoft in SQL Server?

667


can anybody mail me the FAQS for hyperion essbase amd planning

4111


if you use oracle sql*loader , how do you transform data with it during loading?

659


Is there any difference in testing database and data ware housing?

1002


What is meta data and system catalog?

784