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

What is a dimensional model?

1037

What are the differences between a connected lookup and unconnected lookup?

1131

What is the command used to run a batch?

1130

Differences between connected and unconnected lookup?

1273

Under what conditions selecting sorted input in aggregator will still not boost session performance?

1140

What is a joiner transformation and why it is an active one?

1170

Which development components of informatica have the highest usage?

1104

What is informatica etl tool?

1066

Differentiate between joiner and lookup transformation?

1161

What is workflow? What are the components of the workflow manager?

1186

What will be the approach?

1041

What is a snowflake schema?

1051

How will the document be delivered to me?

1133

What is a predefined event?

1139

Differentiate between mapping parameter and mapping variable?

1 1757

Un-Answered Questions { Data Warehouse }

What is program data vector (pdv) and what are its functions?

1335

What kind of application/services uses Redshift database?

Is redshift using primary keys for key-value storage?

can we override a native sql query within informatica? Where do we do it?

1173

What is slibref?

1343

What is the difference between fastload and multiload? Which one is faster?

1306

What are the static cache and dynamic cache in informatica?

1248

Does redshift support unstructured data?

what is program data vector? : Sas-administrator

1126

What is the difference between match merge and one to one merge?

1334

Explain what are components of reportnet?

1035

Explain fastload in teradata?

1156

In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

1260

What is fact extension?

1215

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

1965

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