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.

967

Differentiate between source qualifier and filter transformation?

1578

Explain scd type 3 through mapping.

1010

What is dimensional table?

1066

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?

1050

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

971

Differentiate between router and filter transformation?

1012

Un-Answered Questions { Data Warehouse }

Give some information on report bursting?

994

what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?

10893

explain one complex mapping with logic? sales project?

6670

How many steps etl contains explain with example?

970

i have one file i saved in csv how can i take these file into framework manager

2082

How can I load my data into Amazon Redshift from different data sources like Amazon RDS, Amazon DynamoDB and Amazon EC2?

What is a sparse index?

1084

What is the function of model design accelerator?

958

What is InformaticaPowerCenter?

1136

What are the different table types supported by teradata?

969

How would you define the end of a macro?

1097

Explain the different kinds of facts.

981

Explain what are the vaious etl tools in the market?

944

How is character variable converted into numeric variable and vice versa?

1177

how to debug and test the sas program? : Sas-administrator

1038

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