Data Warehouse Interview Questions
Questions Answers Views Company eMail

What are the benefits of using microstrategy intelligence server?

564

What is embedded metric?

562

While establishing relationship between attributes how do you decide which attribute qualifies as child and which one as parent?

517

What is adaptive metric?

544

What is metadata in microstrategy?

613

Is it possible to use microstrategy object manager while other users are making changes in microstrategy agent?

554

What does microstrategy intelligence server allow users to do?

509

What are pass-through functions and why they are so called? Give some examples.

568

What is transformation metric in microstrategy?

577

What is heterogeneous mapping?

556

What is pass through metrics in microstrategy?

539

How does microstrategy object manager determine if two projects are related?

608

What is a implicit attribute in microstrategy?

1120

What is a conditional attribute in microstrategy?

626

What is microstrategy?

571


Un-Answered Questions { Data Warehouse }

What is Indexing? how did u implement indexing?

1806


Explain if a flat file cotains 1000 records how can I get first and last records only?

527


What is a materialized view log?

547


How can we create a dynamic column name in cognos?

526


root tree will find which is server job and which is parallel job?

1443






define under feeding?

5


what is the difference between == and eq in UNIX shell scripting?

968


I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1463


how many maximum session supports to multiload in teradata ??

1687


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

4436


What are universe requirements?

529


A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?

683


TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1462


What is a compound attribute in microstrategy?

608


Enlist the syntax rules followed in sas statements.

602