Explain the data type of the surrogate key?

571

Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?

590

What is a cube in data warehousing concept?

662

What is called dimensional modelling?

580

Explain the difference between data ware house & data mart?

551

What is execution plan?

749

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

512

Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

517

How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?

560

Is there any rownum object from which we can do this?

522

Explain the difference between oltp and olap?

686

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

563

Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.

644

What is data warehosuing hierarchy?

581

Start a batches with in a batch?

555