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?

1202

What is a merge in datastage?

1270

How to perform incremental load in datastage?

1203

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

1062

What are the functionalities of link partitioner?

1022

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

1037

How can we improve performance of data stage jobs?

1017

What are system variables and sequencers in datastage

1115

Difference between data warehousing and olap?

1090

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

1242

What are the types of containers in datastage?

1191

Explain entity, attribute and relationship in datastage?

1102

Difference between in process and inter process?

1236

What are stage variables and constants?

1147

What are the components of datastage?

1123

Un-Answered Questions { Data Warehouse }

How do you delete duplicate observations in sas?

1072

What is the difference between input and infile statement?

1175

When tpump is used instead of multiload?

1105

How would you configure wh authentication?

952

How can I load my data into Amazon Redshift from different data sources like Amazon RDS, Amazon DynamoDB and Amazon EC2?

what is the limit of the number of the rows and columns available in the worksheet? : Sas-bi

1091

What is the dense rank?

1231

How we can covert server job to a parallel job?

1147

What is lookup table in etl testing?

1183

How to export mappings to the production environment?

908

What are the advantages of raid 1, 1/0, and

980

What is mapplet in informatica?

1057

How to join three sources using joiner? Explain though mapping flow.

1147

What is a data warehousing?

1156

Reusable transformation and shortcut differences

1840

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