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.

917

Differentiate between source qualifier and filter transformation?

1510

Explain scd type 3 through mapping.

918

What is dimensional table?

1004

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

1509

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

1061

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.

1104

Explain in detail about scd type 1 through mapping.

1300

Write the unconnected lookup syntax?

1033

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

1051

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

1112

What is dimensional table? Explain the different dimensions.

1113

What are the types of caches in lookup?

978

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

921

Differentiate between router and filter transformation?

954

Un-Answered Questions { Data Warehouse }

What is SAS?

987

What Proc glm does?

1025

How you can run a graph infinitely in ab initio?

1474

I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1888

define sparse cube?

Explain about core dimension,

921

What is meant by metadata in context of a data warehouse and how it is important?

1130

What r the names of the reports that you prepared?

918

Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar

1924

Explain the differences between normalizer and normalizer transformation?

952

How is union transformation utilized?

952

What is model filter?

1108

I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

2130

What is amazon redshift?

Pdl with an example?

1050

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