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 38159

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

2170

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

1 5305

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

2282

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

2257

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

2 9341

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

JPMorgan Chase, Syntel,

5 33986

what does layout means in terms of Ab Initio?

3 26615

How do we handle if DML changing dynamicaly?

GE, HP, IBM, Mannar Company,

5 32814

How can we test the abintio manually and automation?

JP Group,

1 6952

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

1 5767

How to Improve Performance of graphs in Ab initio?

TCS, Wells Fargo,

2 29582

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

Cap Gemini,

3 20477

How to get DML using Utilities in UNIX?

1 16611

what is skew and skew measurement?

TCS,

2 19567

Un-Answered Questions { Data Warehouse }

How to find value from a column in a dataset?

2154

Explain the difference between informat and format with an example.

1121

Explain why double trailing @@ is used in input statement?

1016

explain the environment varaibles with example?

1031

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1035

Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)

2378

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

2170

Have you worked with packages?

1163

Name the various types of filters?

905

How can you set the client management?

961

How to startup obiee in linux?

832

What is scanmd and md doctor?

1011

Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

2233

How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes

2382

What according to you are the roles and responsibilities of a microstrategy developer?.

961

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