Data Warehouse General Interview Questions
Questions Answers Views Company eMail

What is source qualifier?

1 4698

Difference between DSS & OLTP?

IBM,

5 27298

Explain grouped cross tab?

1228

Hierarchy of DWH?

Accenture, iFlex, IBM, EDS, TCS,

2 11985

How many repositories can we create in Informatica?

Informatica,

14 13875

What is surrogate key?

IBM,

5 12925

What is difference between Mapplet and reusable transformation?

UST,

3 1783

What is aggregate awareness?

2 3804

Explain reference cursor?

787

What are parallel querys and query hints?

880

DWH architecture?

6 10305

What are cursors?

4 3963

Advantages of de normalized data?

2 7333

What is operational data source (ODS)?

2 5636

What is meta data and system catalog?

827


Post New Data Warehouse General Questions


Un-Answered Questions { Data Warehouse General }

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.

601


Compare aggregates and data marts

1196


what is user variable in affinium campaign? and some real time examples.

2728


does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com

4118


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

173


What is a Decision Tree Algorithm?

2338


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

660


What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?

3895


Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?

740


Explain reference cursor?

787


What is meta data and system catalog?

827


In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?

834


What is Discover and Execute in XMLA?

837


Explain clustering algorithm?

742


Can you brief about the Data warehouse project you worked on?

989