Data Warehouse General Interview Questions
Questions Answers Views Company eMail

What is source qualifier?

1 5390

Difference between DSS & OLTP?

IBM,

6 32608

Explain grouped cross tab?

1351




Hierarchy of DWH?

Accenture, iFlex, IBM, EDS, TCS,

2 13272

How many repositories can we create in Informatica?

Informatica,

14 15543

What is surrogate key?

IBM,

5 14731

What is difference between Mapplet and reusable transformation?

UST,

3 2383

What is aggregate awareness?

2 4415




Explain reference cursor?

887

What are parallel querys and query hints?

993

DWH architecture?

6 11423

What are cursors?

4 4521

Advantages of de normalized data?

2 7933

What is operational data source (ODS)?

2 6488

What is meta data and system catalog?

922


Post New Data Warehouse General Questions






Un-Answered Questions { Data Warehouse General }

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

963


Can decision tree be implemented using SQL?

777


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.

688


Compare aggregates and data marts

1341


what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc

1088


What are parallel querys and query hints?

993


What is difference macros and prompts?

869


Difference between PowerPlay transformer and power play reports?

1189


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

792


How did you plan your Data ware house project?

910


Explain grouped cross tab?

1351


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

4553


how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause

855


What is MODEL is Data mining world?

1295


can anybody mail me the FAQS for hyperion essbase amd planning

4360