Data Warehouse Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Teradata (490)
Business Objects (875)
Cognos (1143)
Informatica (2428)

SAS (1049)
Micro Strategy (282)
ETL (315)
OBIEE (92)

Data Warehouse Interview Questions

Questions Answers Views Company eMail

Explain the difference between dw and bi?

1062

Explain what is batch and describe about types of batches?

1092

Explain what are the advantages and disadvantages of reporting directly against the database?

1019

How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?

938

Is there any default username & pwd for bo designer & supervisor?

1040

What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

1056

What is the use of incremental aggregation? Explain me in brief with an example?

1038

Explain what are necessary tasks to install reportnet software?

949

What is difference between query studio and report studio?

1099

What are components of reportnet?

1096

Explain what is power center repository?

1020

How to export mappings to the production environment?

926

What is vdl (view definition language) explain?

1060

What are necessary tasks to install reportnet software?

941

How to generate iqd file from framework manager?

974

Un-Answered Questions { Data Warehouse }

8. How much supervision have you typically received in your previous job?

2268

Differentiate between datastage and informatica?

1201

What is the use of PROC gplot?

1155

What is a transaction control transformation?

1224

What is a sparse index?

1094

Explain what is data validation strategies for data mart validation after loading process?

1043

How can we use external procedural logic in informatica?

934

what techniques and/or procs do you use for tables? : Sas programming

1077

what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?

2641

Connecting to iserver volume using idapi classes(java classes) and after connecting to iserver I want to execute the rox on iserver and also want know the status whether that job is succesfully run or not?

1054

what are the steps to troubleshoot the feeders?

Different ways a project can be moved to production ?...example â€¦.export-import and Version control.

2460

What do you mean by the term data warehousing?

1091

what is log in cognos?

1215

What is a rollup component?

1143

For More Un-Answered { Data Warehouse } Questions Click Here