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

After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can you map these three ports directly to target?

6 13043

What are the Advantages of de normalized data?

3 9067

What is operational data source (ODS)?

7 27706

What is meta data and system catalog?

2 8419

What is factless fact schema?

1 9490

What is confirmed dimension?

3 10012

What is the capacity of power cube?

1 4493

What is the Difference between PowerPlay transformer and power play reports?

1 6288

What is IQD file?

1 7963

What is Cognos script editor?

Cognizant,

4295

What is difference macros and prompts?

2 6556

What is power play plug in?

2 6144

Which kind of index is preferred in DWH?

2 10642

What is hash partition?

2 8598

How can you define a transformation? What are different types of transformations in Informatica?

10 25922

Un-Answered Questions { Data Warehouse }

Explain difference between view and materialized view?

1023

What is upsert statement in teradata?

1198

What is the importance of the exception activity in datastage?

1119

Can you explain new content durability?

1095

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

1232

Explain clustering?

1033

What are the advantages of teradata?

1064

What are the settings that you use to configure the joiner transformation?

1107

Explain scan md?

1142

Why might the optimizer use a table scan when an index is available?

2360

As union transformation gives UNION ALL output, how you will get the UNION output?

1163

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

1203

how do you want missing values handled? : Sas programming

1015

please can you tell me that in companies sas work are doing by through sas coding or sas wizard ??

2144

Describe link sort?

1060

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