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 are the types of containers?

1316

What is the use of datastage designer?

1229

What are stage variables, derivations and constants?

1285

Explain datastage architecture?

1453

What are iconv and oconv?

1305

What are the different plug-ins stages used in your projects?

1128

How do you generate sequence number in datastage?

1143

Define data aggregation?

1154

What are the difference types of stages?

1291

How do you schedule or monitoring the job?

1273

What is staging variable?

1153

Which algorithm you used for your hashfile?

1235

What is apt_config in datastage?

1199

What are the types of jobs we have in datastage?

1124

How can we improve the performance in datastage?

1150

Un-Answered Questions { Data Warehouse }

List out some key concept of SAS

1218

1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?

2295

What are the informatica performance improvement tips

1152

What are the transformations that are not supported in mapplet?

1088

What Is The Difference Between Oltp And Olap?

1174

What can you learn from the SAS log when debugging?

1437

How many types of nodes supported by Redshift and what are the functions of nodes?

-----------------What is Determination Model?

2176

What do you understand by the term 'aggregate cache'?

1027

Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

1045

How do you manage the Parameter files while migrating your data from one environment to another environment?

1070

Can you execute a macro within a macro? Describe. : sas-macro

1160

What is recovering sessions?

1002

Explain piconet?

1016

How would you format some text using css to be verdana and bold?

1128

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