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

How can we delete duplicate rows from flat files?

1169

Differentiate between a database and data warehouse?

1097

How we can use union transformation?

999

What do you understand by a term domain?

1071

Define joiner transformation?

994

Define enterprise data warehousing?

1137

Write the advantages of partitioning a session?

1218

Under what condition selecting sorted input in aggregator may fail the session?

1068

Differentiate between a repository server and a powerhouse?

1054

Explain sessions. Explain how batches are used to combine executions?

960

What are mapplets?

1220

What are data-driven sessions?

1148

How many numbers of sessions can one group in batches?

1023

How many repositories can be created in informatica?

1 1669

Define update strategy?

1123

Un-Answered Questions { Data Warehouse }

What are active and passive transformations?

1031

What is a full backup?

913

How do you Parametermap variables in Quiries?

2212

What are the functions used for character handling?

1183

project Steps,hits, Project level HArd things,Solved methods?

2068

What is the use of datastage designer?

1092

What are the updated features of teradata?

998

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

1014

How to export mappings to the production environment?

839

can you please explain me pre session and post session options?

7412

Explain what is the difference between microstrategy and cognos reporting tool?

1009

How did you plan your Data ware house project?

2248

What are the tracing options available in microstrategy object manager?

916

What is the difference between reading data from an external file and reading data from an existing data set?

1127

Can you fastexport a field, which is primary key by putting equality on that key?

1123

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