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,

1 1151

Informatica settings are available in which file?

Informatica,

1 1052

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

Informatica,

1 1214

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

Informatica,

1 1235

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

Informatica,

1 1203

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

Informatica,

1206

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

Informatica,

1140

What is the purpose of Dataware Control?

CGI,

1113

What steps should be taken to improve Datastage jobs?

1 1135

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

1 1218

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

1 1214

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1 1290

Define Merge?

1 1374

Explain Quality stage?

1 1221

Explain how a source file is populated?

1 1424

Un-Answered Questions { Data Warehouse }

Explain scd type 3 through mapping.

1068

What is node? How many nodes and amps used in your previous project?

1169

What is the purpose of Dataware Control?

1113

Hi friends, what are the new features in abinito3.0?

2855

Connecting to iserver volume using idapi classes(java classes) and after connecting to iserver I want to execute the rox on iserver and also want know the status whether that job is succesfully run or not?

1097

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1657

Explain what is aggregate table and aggregate fact table ... Any examples of both?

1172

What is the difference between business requirement document and use case document.

1076

How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

1196

i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

2166

does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com

6062

How do you remove duplicate records in informatica? And how many ways are there to do it?

1226

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

2084

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

1936

how many reports have u created ? explain a few.

2155

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