Data Warehouse General Interview Questions
Questions Answers Views Company eMail

Start a batches with in a batch?

543

How to create different types of templates?

505

What is the difference between connected and unconnected stored procedures?

539

What is a relationship?

565

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?

495

Where the applications and where

510

How many project sources we can create in metadata?

550

What is the difference between static cache and dynamic cache?

512

ware house management system is used?

568

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

504

What are partition points?

555

How can we transform row to column?

1 768

How to stop a batch?

530

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

499

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

508


Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is the definition of cube in datawarehousing?

549


Explain what is fact less fact table? Where you have used it in your project?

507


What is the difference between filter and lookup transformation?

599


Explain is fact table?

503


What is the main difference between star and snowflake star schema? Which one is better and why?

546






Why fact table is in a normal form?

546


How can we run the graph?

571


Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?

480


I know of using applysimple, but there are other ways too?

551


What is data warehosuing hierarchy?

573


What is data analysis? Where it will be used?

549


How do we design a universe?

514


How do you define data block size?

583


What is the difference between agglomerative and divisive hierarchical clustering?

641


Explain vldb?

616