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

Can you create an event based schedule in microstrategy? How?

1101

Do you know how to prioritize the excecution of a report?

1015

what is a security filter?

1059

what do you mean by passthrough functions?

1020

Your colleague installed microstrategy on solaris or unix without root access. Will he be able to start/ restart this server?

1023

Explain batch?

1036

Is it possible to apply themes to microstrategy web? How?

1004

What according to you are the roles and responsibilities of a microstrategy developer?.

1066

What do you mean by dimensional modeling and relational modeling?

943

Explain access control?

1066

Explain fact?

1031

what are the different types of tests done on a microstrategy report?

948

What do you mean by static prompt report?

1038

Explain level extension?

1122

what do you mean by security filter?

1065

Un-Answered Questions { Data Warehouse }

Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.

1149

I have a SCD Type 2 Dimention for Location In which A Sales Office in Having two Surrogate Keys just because of the change in it's Sales Group. SKey SalesGroup Sales Office BeginDate EndDate 280 SG1 SO1 01APR2000 01APR2010 281 SG2 SO1 02APR2010 31MAR2999 Now while loading the Fact, the Lookup ir returning SKey 280 for records before and after 01APR2010. I am not able to give WHERE condition in the Lookup Properties (TranDate between BeginDate and EndDate). Please help.

2204

What is apt_config in datastage?

1199

Can you define drill down and drill up?

1085

What is object stores?

1041

What are the automatic variables for macro? : sas-macro

1335

You have got the requirement from a client. Explain the technical approach you will take now.

1036

what are the considerations when picking a SAS/STAT procedure?

3426

What is tracing level and what are the types?

1017

What do you know about partition and also tell us about partition components in abinitio?

1108

What do you mean incremental aggregation?

1131

explain the environment varaibles with example?

1142

Explain attribute role?

1156

How do you promote a non-reusable transformation to reusable transformation?

1188

How to use pmcmd utility command?

1077

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