Data Warehouse General Interview Questions
Questions Answers Views Company eMail

Start a batches with in a batch?

725

How to create different types of templates?

696

What is the difference between connected and unconnected stored procedures?

755

What is a relationship?

733

Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?

707

Where the applications and where

692

How many project sources we can create in metadata?

741

What is the difference between static cache and dynamic cache?

694

ware house management system is used?

739

What function should we use to display the value entered or selected by a user in response to a prompt?

695

What are partition points?

729

How can we transform row to column?

1 1052

How to stop a batch?

712

How to allow a dynamic selection of a column for a measure in a chart,without using variable?

681

If two relational tables are connected to sq trans, what are the possible errors it will be thrown?

691


Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is perform recovery?

709


After the generation of a report to whom we have to deploy or what we do after the completion of a report?

686


ware house management system is used?

739


What are snapshots? What are materialized views & where do we use them?

726


List down some of the real time data-warehousing tools?

730


Explain what is a staging area? Do we need it? What is the purpose of a staging area?

698


Explain vldb?

809


Tell me what is degree of a relation?

697


What are the various transformation available?

745


what is difference between drill & scope of analysis?

699


How do you create surrogate key using ab initio?

729


Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?

723


Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?

684


In document how to create metrics?

734


In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?

741