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

----------------Describe DWH Architecture?

Bank Of America,

2071

-------------How you design DWH?

Bank Of America,

2316

-------------How to create a PortalTab?

Cap Gemini,

1 5137

-------------How to do Bursting a Report?

Cap Gemini,

1 6658

--------------Explain Table of contents?

Cap Gemini,

2024

----------------Diff b/w Dimensional modeling and Relational modeling?

Cap Gemini, L&T,

2 15010

-------------Diff b/w Union and Unionall?

Cap Gemini,

3 9251

-----------------What is Singleton?

BoA, Cap Gemini, TCS,

1 16895

-------------------What is StarShema?

Cap Gemini,

1 5314

------------------What is Inline Query?

Cap Gemini,

2229

----------------What is Surrogate Key?

Cap Gemini,

1 6844

Diff b/w surrogate Key and Primary Key?

Cap Gemini,

2 8774

------------------What is Focalpoint?

1 4051

------------------- What is Busschema?

Cap Gemini,

1 5655

--------------what is MemberCaption?

1 4675

Un-Answered Questions { Data Warehouse }

What are the various etl tools in the market?

1073

Explain snowflake schema?

1039

Explain meta data?

1037

During the Display time, how is the sequence generated by Teradata?

1057

How you prepared reports for OLAP?

1597

What all the types of jobs you developed?

1181

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1906

What are the different options associated with dsjob command?

1442

Which component has onread method and what it is used for?

984

Name the command line functions to import and export the DS jobs?

1157

In a star schema, are foreign key constraints between facts and dimensions neccessary?

979

Describe primary index in teradata?

1000

how to perform single sign in cognos by using url?

1156

How can a transformation be made reusable?

1171

How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro

1051

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