Data Warehouse Interview Questions
Questions Answers Views Company eMail

Is olap services sold as a separate product?

649

Name the various types of filters?

696

Compare microstrategy and tableau.

683

How we can decided drilling options for an attribute?

661

Write different kinds of objects in microstrategy?

707

Name the types of transformation?

651

What are the programs that we can do with the microstrategy architect?

715

What is a local lookup?

853

What are the benefits of data analyzing?

826

What is data encoding?

906

What is the architecture of abinitio?

823

What is the syntax for m_dump in abinitio?

1255

List out some of the air commands used in abintio?

1006

What does edp stand for?

859

What is abinitio?

856


Un-Answered Questions { Data Warehouse }

Explain what are the modules in power mart?

726


How to go to the older version for a mapping?

736


Explain the term 'database' related to relational database management system?

726


How do you load first and last records into target table?

864


What are the components of ascential data stage?

813






What is a partition and what are the different types of partition components in abinitio?

916


In a star schema, are foreign key constraints between facts and dimensions neccessary?

695


what are the devoleper roles in real time? plz tell i am new to datastage....

1819


--------------Explain Table of contents?

1706


For what purposes have you used sas macros? : sas-macro

673


What is execution plan?

885


Explain what is the difference between view filter and report filter?

709


What is difference between custom hierarchy and report based hierarchy?

704


what is sas application server, database server, sas olap server and sas metadata server? : Sas-di

695


what are the other factors of the database on which the loading performance depend?

1628