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

Explain the different dimensions.

1010

Differentiate between source qualifier and filter transformation?

1634

Explain scd type 3 through mapping.

1055

What is dimensional table?

1135

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1648

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1182

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1225

Explain in detail about scd type 1 through mapping.

1631

Write the unconnected lookup syntax?

1133

Write the unconnected lookup syntax and how to return more than one column.

1156

How do you remove duplicate records in informatica? And how many ways are there to do it?

1209

What is dimensional table? Explain the different dimensions.

1258

What are the types of caches in lookup?

1096

What are the types of caches in lookup? Explain them.

1015

Differentiate between router and filter transformation?

1066

Un-Answered Questions { Data Warehouse }

What are the ways to do a “table lookup” in sas?

1081

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

1065

Can you explain the advantage of using shortcuts?

1079

Why is the case expression used in teradata?

1138

What is the difference between absolute filtering and standard filtering in microstrategy?

1037

Notification Activity

1463

What is data analysis?

1009

Explain what are fact, dimension, and measure?

1049

How can we run the graph? How can we schedule the graph in unix?

1007

Which query language is used by amazon redshift?

How to view every column and the columns contained in indexes in teradata?

1103

What is dynamic aggregation in microstrategy?

1027

what does the run statement do? : Sas programming

1102

Which command is used to save logs in the external file?

1156

How to improve session performance in aggregator transformation?

1032

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