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

What is .abinitiorc and What it contain?

CSC,

3 38447

What are the components new in 2.14 compared to 1.8 and State the usage of the components?

2224

Describe the effect of the "checkpoint" t-sql statement?

1 5413

Describe what the SQL Server tempdb and tlog files are used for?

2340

Why might the optimizer use a table scan when an index is available?

2311

How might you quantitatively measure an improvement made to a query?

2 9474

What is the difference between sandbox and EME, can we perform checkin and checkout through sandbox?

JPMorgan Chase, Syntel,

5 34217

what does layout means in terms of Ab Initio?

3 26801

How do we handle if DML changing dynamicaly?

GE, HP, IBM, Mannar Company,

5 33072

How can we test the abintio manually and automation?

JP Group,

1 7048

How will you use EME for view or publish metadata reports using EME?

1 5858

How to Improve Performance of graphs in Ab initio?

TCS, Wells Fargo,

2 29751

what is the difference between .dbc and .cfg file?

Cap Gemini,

3 20732

How to get DML using Utilities in UNIX?

1 16722

what is skew and skew measurement?

TCS,

2 19680

Un-Answered Questions { Data Warehouse }

What is spool space? Why do you get spool space errors?

1020

How can repository reports be accessed without sql or other transformations?

1219

What information is shared by the application across microstrategy web nodes?

1047

Tell e how how dealt with..

2253

What are objects?

1018

What is complex mapping?

1120

Explain what are the different types of transformation available in informatica.

1149

What is surrogate key? Where we use it explain with example?

931

What is a repository? And how to add it in an informatica client?

1149

Why are meta service important then other services?

974

what is sas business intelligence? : Sas-bi

1181

What is an aggregator transformation?

1096

can u any challenge your project?

2033

how does sas handle missing values in formats? : Sas programming

1139

What are the difficulties u faced while doing vital signs table or dataset?

2393

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