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

Where are the source flat files kept before running the session?

Informatica,

1146

Informatica settings are available in which file?

Informatica,

1052

What is option by which we can run all the sessions in a batch simultaneously?

Informatica,

1205

How to update or delete the rows in a target, which do not have key fields?

Informatica,

1235

What is a repository? And how to add it in an informatica client?

Informatica,

1200

Name at least 5 different types of transformations used in mapping design and state the use of each.?

Informatica,

1202

How to create the source and target database connections in server manager?

Informatica,

1138

What is the purpose of Dataware Control?

CGI,

1110

What steps should be taken to improve Datastage jobs?

1130

In Datastage, how you can fix the truncated data error?

1216

Name the command line functions to import and export the DS jobs?

1210

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1287

Define Merge?

1374

Explain Quality stage?

1218

Explain how a source file is populated?

1422

Un-Answered Questions { Data Warehouse }

How to define a cube??

1000

how can I test reports in cagnos?

1220

What is informatica architecture?

1119

What is conformed fact?

1161

What is derived metric?

1044

What are session parameters ? How do you set them?

1908

is there any difference between operational database and data base?if yes what r they?

2127

differentiate between two-tier, three-tier and four-tier connections.

1047

What is amazon redshift?

Is Redshift similar to RDS ?

Difference between zabo and webi?

1161

What are target types on the server?

1049

what are the benefits of data integration? : Sas-di

1194

What is Sequence clustering algorithm?

2081

1. Explain your project.

2103

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