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 fact degradation?

916

What is report as filter in microstrategy?

870

What is smart metric?

918

Does microstrategy intelligence server run on windows®, unix®, or linux®?

920

What is non-aggregate metric?

939

What are the types of facts in microstrategy?

971

What is the difference between absolute filtering and standard filtering in microstrategy?

916

What information is shared by the application across microstrategy web nodes?

989

What is percent-to-total shortcut metric in microstrategy?

925

What are the different types of metrics available in microstrategy?

908

What are vldb properties in microstrategy?

948

What is a compound attribute in microstrategy?

977

What is the conflict resolution window?

980

Can schema objects be copied across projects with microstrategy object manager?

938

How do we resolve attribute roles in microstrategy?

1076

Un-Answered Questions { Data Warehouse }

Difference between SAS STATA & SPSS?

1062

What is difference between informatica power mart and power center?

948

When can we choose the Redshift ?

How we can monitor the performance of Redshift data warehouse cluster.

What are the various types of transformation?

1098

Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance

5006

What is the use of having index on table?

956

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

2000

Do we need an etl tool?

945

What are the components used in smp and massively parallel processing (mpp) machines?

1004

What are the special input delimiters used in SAS?

1105

What are the vldb properties? Which level of vldb configurations have the highest precedence?

889

How we can covert server job to a parallel job?

1064

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

3417

what is SDLC way of code development?

1971

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