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

Difference between sequential file and data set?

1155

What is a merge in datastage?

1221

How to perform incremental load in datastage?

1150

What is the flow of loading data into fact & dimensional tables?

1030

What are the functionalities of link partitioner?

988

What is the purpose of pivot stage and types of containers in datastage

1006

How can we improve performance of data stage jobs?

978

What are system variables and sequencers in datastage

1082

Difference between data warehousing and olap?

1060

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

1196

What are the types of containers in datastage?

1153

Explain entity, attribute and relationship in datastage?

1061

Difference between in process and inter process?

1183

What are stage variables and constants?

1111

What are the components of datastage?

1073

Un-Answered Questions { Data Warehouse }

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3712

What are various etl tools in the market?

955

What are the uses of sas?

1192

What are the implications?

1645

How do you do backup and recovery in teradata?

976

Are you involved in writing the inferential analysis plan? Tables specfications?

2526

What is the difference between proportion and average?

3282

Why cognos scenario is used?

1022

what is the hint? how to use it to reduce the query processing in program?

7690

Explain your project of banking domian.

1619

how does sas handle missing values in formats? : Sas programming

1097

Demonstrate experience in maintaining quality process standards?

2477

Briefly state different between data ware house & data mart?

1017

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1741

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1857

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