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 is the sql query overwrite in source qualifier in informatica

Informatica,

1090

Why union transformation is an active transformation?

Informatica,

1047

What are the limitations of joiner transformation?

Informatica,

1114

Explain joiner transformation in informatica

Informatica,

1124

What are the informatica performance improvement tips

Informatica,

1093

What are the mapping parameters and mapping variables?

Informatica,

1204

To import the flat file definition into the designer where should the flat file be placed?

Informatica,

1061

How are the sources and targets definitions imported in informatica designer?

Informatica,

1107

What are the data movement modes in informatica?

Informatica,

1159

How to generate or load values in to the target table based on a column value using informatica etl tool.

Informatica,

1076

Explain sql transformation in script mode examples in informatica

Informatica,

1135

What are Dimensional table?

Informatica,

1057

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

Informatica,

1108

While importing the relational source definition from the database, what are the metadata of source that will be imported?

Informatica,

1269

Explain the mapping variable usage example in informatica

Informatica,

1165

Un-Answered Questions { Data Warehouse }

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8223

Explain PDL with an example?

1324

How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?

2126

Why do we use exception activity in Datastage?

1314

When do you use sql override in a lookup transformation?

1099

What is a grid in Informatica?

1071

What is the difference between operational data stage (ods) and data warehouse?

1242

what is the difference steps for data modeling?

2596

What are all difference between business objects 6.5 and xi r2?

1033

what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw

2320

what are the new features included in the new version of sas i.e., Sas 9.1.3? : Sas programming

1079

what is the difference between list report and crosstab report?

1185

What is the difference between datawarehousing and businessintelligence?

1100

What do you mean by a transaction file and how it is different from that of a sort file?

1048

Hi, If anyone has base SAS certification dumps, please share.

1868

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