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

I have the source like col1 col2 a l b p a m a n b q x y How to get the target data like below col1 col2 a l,m,n b p,q x y

DELL,

2 7543

difference between informatica 8.6 and 9

Atos Origin, BA Continnum Solutions, Core Logic,

3 44238

What are the different types of OLAP. Which one is Cognos Powercube?

HSBC,

2 7158

How can I remove header from output data set?

2668

1.what is activity count? 2.what is skew factor? how it's working explain brefily

Satyam,

5 33115

What is the diff between abinitiorc and .abinitiorc files ?

IBM, Infosys, TCL,

1 26719

11. What is the use of allocate()?

TCL,

1 5662

. What is dynamic lookup ?

CTS,

1 13234

What is regex (lookup)? When you should use it?

HCL,

3 15872

Why creation of temporary files depends on the value of MAX CORE

HCL,

1 6159

What is dependent parameter ?

HCL,

1 7111

What is the significance of record required indicator of Join component ?

HCL,

1 8210

. What is flow buffering ? How it reduces the chances of having deadlock ?

HCL,

1 7883

When we should use 'jobid' for commit table (Output table component??

HCL,

1 9213

Layout - L1*, L1 - What is the difference

3 13578

Un-Answered Questions { Data Warehouse }

What is an er diagram?

1110

Can tm1 web be set up for load balancing?

how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u

1791

What is sq transformation?

1235

what is the -ve test case in your project.

2465

Describe the architecture of datastage?

1067

What are the main services provided by application tier?

1032

What are the important features of datastage?

1207

What is meant by drill down?

1037

Explain what is a three tier data warehouse?

1038

What is the difference between a connected look up and unconnected lookup?

1010

What are the various types of transformation?

1248

Explain the difference between view and materialized view?

984

What is main difference mapplets and mapping?

1283

Difference between PowerPlay transformer and power play reports?

2565

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