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.

965

Differentiate between source qualifier and filter transformation?

1578

Explain scd type 3 through mapping.

1004

What is dimensional table?

1061

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

1580

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

1125

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.

1166

Explain in detail about scd type 1 through mapping.

1553

Write the unconnected lookup syntax?

1084

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

1110

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

1167

What is dimensional table? Explain the different dimensions.

1172

What are the types of caches in lookup?

1048

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

969

Differentiate between router and filter transformation?

1012

Un-Answered Questions { Data Warehouse }

What is the architecture of abinitio?

1097

what is Forward,Reverse and Re_engineering?

2194

What are the operations that support avoiding duplicate record?

1443

Explain the difference between data ware house & data mart?

951

5. Which type of report you build more, list, crosstab or chart and why?

2020

What is amazon redshift odbc?

What is the difference between 'using group by in the sql of the report' and 'having a group section in the report'?

934

Explain scan md?

1078

Tell me more about the parameters in macro? : sas-macro

1053

On which interface you will be working as a developer?

1042

How can one find bugs in job sequence?

1410

How do you convert basic cube to transaction cube and transaction cube to basic cube?

2230

What is ds designer?

1103

Explain what is sandbox?

1086

How do you update the records with or without using update strategy?

1114

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