Un-Answered Questions { Data Warehouse General }

What is perform recovery?

544


Can we start and stop single session in concurent bstch?

532


Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?

587


How to provide security in frame work manager for a query subject?

524


How to improve session performance in aggregator transformation?

533


Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?

576


What is a functional dependency f said to be minimal?

548


How to eliminate duplicate rows from flat file?

510


How to generate the cubes in framework manager?

552


What are target types on the server?

556


What is difference between model & package?

572


What is the difference between constraind base load ordering and target load plan?

650


How to add a number to a macro variable?

553


What is the difference between drill through and masterdetail reports?

544


What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?

535