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 7429

difference between informatica 8.6 and 9

Atos Origin, BA Continnum Solutions, Core Logic,

3 44109

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

HSBC,

2 7069

How can I remove header from output data set?

2630

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

Satyam,

5 32893

What is the diff between abinitiorc and .abinitiorc files ?

IBM, Infosys, TCL,

1 26584

11. What is the use of allocate()?

TCL,

1 5573

. What is dynamic lookup ?

CTS,

1 13146

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

HCL,

3 15722

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

HCL,

1 6071

What is dependent parameter ?

HCL,

1 7010

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

HCL,

1 8126

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

HCL,

1 7803

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

HCL,

1 9104

Layout - L1*, L1 - What is the difference

3 13443

Un-Answered Questions { Data Warehouse }

What all the types of jobs you developed?

1181

how to do user inputs and command line arguments in sas?

3049

What do you mean by caching in teradata?

1065

What is the difference between drill through, drill across?

1086

how can you import .csv file in to sas? : Sas programming

1100

what is the size of your data warehousing?

2096

What's the layout of parameter file (what does a parameter file contain?)?

2388

Explain heterogeneous mapping?

988

What is a dimensional model?

986

hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2865

Explain the use of proc print and proc contents?

965

Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?

1955

What are vldb properties in microstrategy?

1048

How to identify ppi columns?

1182

What are the steps involved in creating dimensional modeling process?

1022

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