Data Warehouse General Interview Questions
Questions Answers Views Company eMail

What is source qualifier?

1 5192

Difference between DSS & OLTP?

IBM,

5 31463

Explain grouped cross tab?

1325




Hierarchy of DWH?

Accenture, iFlex, IBM, EDS, TCS,

2 12932

How many repositories can we create in Informatica?

Informatica,

14 15147

What is surrogate key?

IBM,

5 14274

What is difference between Mapplet and reusable transformation?

UST,

3 2236

What is aggregate awareness?

2 4275




Explain reference cursor?

861

What are parallel querys and query hints?

965

DWH architecture?

6 11120

What are cursors?

4 4381

Advantages of de normalized data?

2 7814

What is operational data source (ODS)?

2 6272

What is meta data and system catalog?

898


Post New Data Warehouse General Questions






Un-Answered Questions { Data Warehouse General }

How do you setup Lo-cockpit?

1765


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

2819


What is difference macros and prompts?

837


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

4436


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

383


What are algorithms provided by Microsoft in SQL Server?

784


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

1175


Explain grouped cross tab?

1325


What are different deliverables according to phases?

2046


What is Discrete and Continuous data in Data mining world?

1124


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

920


i have scheduled a report in a job in the cognos8.3 which would send the reports to the respective user ,now the repot ran and is sent to the respective user but it contains some unwanted data. So based on the senario can any one tell me that can we recall back the report ??????

719


can anybody mail me the FAQS for hyperion essbase amd planning

4321


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

776


Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar

735