Data Warehouse General Interview Questions
Questions Answers Views Company eMail

What is source qualifier?

1 4542

Difference between DSS & OLTP?

IBM,

5 25541

Explain grouped cross tab?

1200

Hierarchy of DWH?

Accenture, iFlex, IBM, EDS, TCS,

2 11663

How many repositories can we create in Informatica?

Informatica,

14 13436

What is surrogate key?

IBM,

5 12516

What is difference between Mapplet and reusable transformation?

UST,

3 1660

What is aggregate awareness?

2 3648

Explain reference cursor?

777

What are parallel querys and query hints?

850

DWH architecture?

6 10056

What are cursors?

4 3872

Advantages of de normalized data?

2 7174

What is operational data source (ODS)?

2 5465

What is meta data and system catalog?

795


Post New Data Warehouse General Questions


Un-Answered Questions { Data Warehouse General }

What is meta data and system catalog?

795


What is Analysis Services?

688


can anybody mail me the FAQS for hyperion essbase amd planning

4138


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.

590


Explain clustering algorithm?

728


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

139


Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

803


What is Sequence clustering algorithm?

587


What are algorithms provided by Microsoft in SQL Server?

677


How are models actually derived?

609


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

4053


Compare aggregates and data marts

1182


What are the different problems that ?Data mining? can solve?

944


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

710


Can decision tree be implemented using SQL?

638