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 7441

difference between informatica 8.6 and 9

Atos Origin, BA Continnum Solutions, Core Logic,

3 44117

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

HSBC,

2 7073

How can I remove header from output data set?

2633

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

Satyam,

5 32901

What is the diff between abinitiorc and .abinitiorc files ?

IBM, Infosys, TCL,

1 26592

11. What is the use of allocate()?

TCL,

1 5577

. What is dynamic lookup ?

CTS,

1 13152

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

HCL,

3 15736

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

HCL,

1 6075

What is dependent parameter ?

HCL,

1 7011

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

HCL,

1 8131

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

HCL,

1 7808

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

HCL,

1 9113

Layout - L1*, L1 - What is the difference

3 13456

Un-Answered Questions { Data Warehouse }

What is "fatal error/rdbms code 3996" error?

1275

What is surrogate key? Explain with examples.

1167

How can you first report in Business Objects by using broadcast agent?

3067

Explain the use of proc gplot? : sas-grid-administration

998

1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

2094

What are normalization, first normal form, second normal form and third normal form?

1061

Design a mapping to load a target table with the following values from the above source?

1355

how are numeric and character missing values represented internally? : Sas programming

1155

Differentiate between datastage and informatica?

1191

What is joiner transformation?

1016

Explain what is ods (operation data source)?

998

what is difference between drill & scope of analysis?

1101

Explain how many types of dimensions are available in informatica?

1107

please can you give me some banking domine calculations developed in framework manager plzzzzz thank you.

2197

How do you specify the number of iterations and specific condition within a single do loop?

1114

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