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

Define repository in terms of OBIEE?

1 3254

What is the end to end life cycle of OBIEE?

1 8509

If you have 3 facts and 4 dimension and you need to join would you recommend joining fact with fact? If no than what is the option? Why you won’t join fact to fact?

1 4422

What is connection pool and how many connection pools did you have in your last project?

1 3642

What is the purpose of Alias Tables?

1 3323

How do you define the relationship between facts and dimensions in BMM layer?

1 3606

Did you create any new logical column in BMM layer, how?

1 3157

Can you use physical join in BMM layer?

1 4239

Can you use outer join in BMM layer?

1 4341

What is level based metrics?

1 3125

What is logging level? Where can you set logging levels?

1 3286

What are different types of variables?

1 2985

What is Authentication? How many types of authentication do we have in OBIEE?

1 3105

What is object level security?

1 3347

What is data level security?

1 3029

Un-Answered Questions { Data Warehouse }

What are the data marts?

984

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

2025

What are the databases that informatica can connect to windows?

1059

Mention some ways for improving performance of a graph?

1088

What is the function that transfers a string into a decimal?

1166

what is smart metrics in microstrategy?

1039

How can you set the session management?

1129

What is PDV?

1162

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1555

Explain er diagram?

999

What is the difference between %local and %global? : sas-macro

1193

What are the main differences you have observed between 7.x and 8.x version of datastage?

1089

What is the difference between validated and compiled in the datastage?

1298

Differentiate primary key and partition key?

986

What are the types of folder present in cognos?

1099

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