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 38446

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 34214

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 33070

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 5857

How to Improve Performance of graphs in Ab initio?

TCS, Wells Fargo,

2 29749

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

Cap Gemini,

3 20732

How to get DML using Utilities in UNIX?

1 16721

what is skew and skew measurement?

TCS,

2 19679

Un-Answered Questions { Data Warehouse }

What are the conditions needed to improve the performance of informatica aggregator transformation?

1093

Compare ETL & Manual development?

950

What are the different types of data warehousing?

957

What are the multiload utility limitations?

1055

what are the basic features of cognos tm1?

What are the features of complex mapping?

1158

what are passthrough functions?

957

------------- How to identify the Revenue Column in Report?

2387

How to design file watch jobs?

972

What information is provided by .dbc file extension for connecting to the database?

1170

Explain grouped cross tab?

2626

What are session timeout and application timeout?

1018

what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?

2070

What is a junk dimension? What is the difference between junk dimension and degenerated dimension?

933

Explain the parallel data extension in teradata?

1094

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