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.

1006

What is dimensional table?

1063

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

1581

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.

1167

Explain in detail about scd type 1 through mapping.

1555

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?

1049

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

970

Differentiate between router and filter transformation?

1012

Un-Answered Questions { Data Warehouse }

Explain what is the difference between microstrategy and cognos reporting tool?

1074

Why did ibm cognos tm1 web change the technology from .net to java?

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1708

Explain why are oltp database designs not generally a good idea for a data warehouse?

1030

Why update strategy and union transformations are active? Explain with examples.

1240

Explain the data types present in bo n wht happens if we implement view in the designer n report?

981

Have you used macros? For what purpose you have used? : sas-macro

1041

What are the components used in smp and massively parallel processing (mpp) machines?

1057

What are the co> operating system’s assorted library of integrated components?

1118

Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

2280

What is enterprise data warehousing?

1047

what is unit testing?tell me proceedure

2222

What is embedded metric?

990

hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message

2057

What is data stream and data adapter is it same are different? Explain?

970

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