Why should you put your data warehouse on a different system than your oltp system?

638

What is the difference between business requirement document and use case document.

731

Explain about alerts in bos, under what situation we need to use alerts?

720

What are the advantages of using informatica as an etl tool over teradata?

730

What can we do to improve the performance of informatica aggregator transformation?

793

Can reports be executed in off-peak periods?

722

How to load the data from a flat file into the target where the source flat file name changes daily?

732

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

643

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

1929

What is flow buffering ? How it reduces the chances of having deadlock ? How to use in abinitio graph?

2972

Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?

693

How to do the error handling of if ur source is flatfiles?

1662

how do u set partition points in the mapping?

1914

What are the benefits of datastage?

874

What is the difference between absolute filtering and standard filtering in microstrategy?

709