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

Whether dimension table can have numeric value?

1149

Have you have ever worked in unix environment and why it is useful in datastage?

1133

Differentiate between hash file and sequential file?

1072

Define project in datastage?

1093

How to clean the datastage repository?

1127

How rejected rows are managed in datastage?

1522

Does datastage support slowly changing dimensions ?

1105

How many types of hash files are there?

1185

Nls stands for what in datastage?

1190

Define meta stage?

1202

Define orabulk and bcp stages?

1122

Define repository tables in datastage?

1158

How complex jobs are implemented in datstage to improve performance?

1042

Can you explain how could anyone drop the index before loading the data in target in datastage?

1504

How a routine is called in datastage job?

1108

Un-Answered Questions { Data Warehouse }

Compare dataset and fileset?

1039

What is m_dump?

1235

where we cannot use sorter Transformation. if we use then we will not get correct data?

2199

Suppose you find the term validation mentioned with a set of data, what does that simply represent?

1036

what is log in cognos?

1200

complex mapping ur project u r invlve can u explain and give real time example give me ?

2298

please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance

2483

how do u set partition points in the mapping?

2596

difference between repository database and repository service?

1151

1. Explain your project.

2047

What do you mean by derived metrics?

996

What are the components of datastage?

1123

what is index?how it can work in informatica

2040

Explain joiner transformation in informatica

1124

Define APT_CONFIG in Datastage?

1080

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