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,

2064

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

Bank Of America,

2312

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

Cap Gemini,

1 5133

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

Cap Gemini,

1 6656

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

Cap Gemini,

2024

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

Cap Gemini, L&T,

2 15001

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

Cap Gemini,

3 9242

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

BoA, Cap Gemini, TCS,

1 16884

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

Cap Gemini,

1 5312

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

Cap Gemini,

2224

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

Cap Gemini,

1 6840

Diff b/w surrogate Key and Primary Key?

Cap Gemini,

2 8769

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

1 4051

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

Cap Gemini,

1 5653

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

1 4672

Un-Answered Questions { Data Warehouse }

What are the string manipulation operators and functions associated with teradata?

1090

Explain translate function?

1207

In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

1501

Give one reason when you need to consider multiple data processing?

1174

How the ipc stage work?

1127

What are different table types used in teradata?

1042

How can I remove header from output data set?

2622

What is fact? What are the types of facts?

1117

What is the very basic difference between data warehouse and operational databases?

967

How do you update the records with or without using update strategy?

1116

What is Additive function?

2033

Can you define set to be cardinality?

1011

Define ramp limit in ab initio?

1286

What information does a .dbc file extension provides to connect to the database?

1233

What is called Cognos powerplay?

1083

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