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 38762

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

2280

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

1 5495

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

2392

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

2359

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

2 9600

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

JPMorgan Chase, Syntel,

5 34422

what does layout means in terms of Ab Initio?

3 26963

How do we handle if DML changing dynamicaly?

GE, HP, IBM, Mannar Company,

5 33308

How can we test the abintio manually and automation?

JP Group,

1 7136

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

1 5944

How to Improve Performance of graphs in Ab initio?

TCS, Wells Fargo,

2 29885

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

Cap Gemini,

3 20924

How to get DML using Utilities in UNIX?

1 16818

what is skew and skew measurement?

TCS,

2 19795

Un-Answered Questions { Data Warehouse }

my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?

2051

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2245

What are the different clients of powercenter?

1118

Scheduling properties,whats the default (sequential)

2014

How to schedule the report in b.o?

1104

What is the importance of the exception activity in datastage?

1116

Explain the most common data types used in teradata?

1127

What are algorithms provided by Microsoft in SQL Server?

2113

what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2877

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

10333

What is sequence generator transformation in informatica?

1127

What are the benefits of data analyzing?

1238

how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

865

What do the put and input function do?

1117

How do you add a number to a macro variable? : sas-macro

1057

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