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,

1076

Informatica settings are available in which file?

Informatica,

990

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

Informatica,

1141

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

Informatica,

1178

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

Informatica,

1149

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

Informatica,

1159

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

Informatica,

1090

What is the purpose of Dataware Control?

CGI,

1048

What steps should be taken to improve Datastage jobs?

1073

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

1160

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

1155

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1215

Define Merge?

1317

Explain Quality stage?

1155

Explain how a source file is populated?

1365

Un-Answered Questions { Data Warehouse }

Explain er diagram?

991

Under which circumstances, informatica server creates reject files?

1094

What are fact, dimension, and measure?

1335

What are the different types of variables in obiee? Explain

904

To see hidden files in LINIX?

1527

waht type of interface is used for testing the data in informatica

2256

New coloums are added in database, then how you know in report level

1555

What is the difference between informatics 7x and 8x and what is latest version?

1085

name several ways to achieve efficiency in your program? : Sas programming

1070

What is logical data model?

1203

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1203

What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?

1102

How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?

1059

what are Lookup caches options? Including persistent caches.

1971

Explain level extension?

1052

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