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

What is microstrategy intelligence server?

1035

Difference between project merge and object manager in microstrategy?

993

what are passthrough functions?

956

What are different types of metrics in microstrategy?

963

What is the command manager?

1001

What are intelligent cubes?

997

What is purpose of having conditionality in metrics in microstrategy?

978

What are the various ways of incorporating security in microstrategy?

997

What is a logical size of a table and what does it depend on?

967

What is an object prompt in microstrategy?

1008

What are report caches and how many types are there?

972

Can we access multiple operational databases from within a single microstrategy project?

1052

What are the tracing options available in microstrategy object manager?

982

What is rank metrics in microstrategy?

981

What is a joint child?

946

Un-Answered Questions { Data Warehouse }

What is the use of teradata system software?

1037

How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.

2445

what are the types of interactive display types? : Sas-bi

1099

What is a implicit attribute in microstrategy?

1657

What is difference between primary key and unique key constraints?

989

Explain append procedure?

1084

What is brodcasting and replicate?

1209

Can some tell me at which level pdl gets resolved when parameters are resolved in abinitio? Also what happens in dml evaluation during parameter evaluation ?

1344

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

2072

What is meta data and system catalog?

2300

What is defined as partial backup?

1075

What are the business intelligent tools to which Redshift can be integrated with?

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3794

what are slowly changing dimensions? Why we are used scd?

1125

Differentiate primary key and partition key?

979

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