1)What is configuration your file structure
2)I have two databases both are Oracle while loading data
from source to target the job takes 30 min but I want to
load less time how?
Define data aggregation?
What is the purpose of pivot stage?
what r the sources u need to create the datastage?
What is the flow of loading data into fact & dimensional tables?
In merge stage can we update the values?
which cache supports connected & un connected Lookup
how can u find out the datastage job is running on how many nodes
What are the different common services in datastage?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
how to call routines in stages?
What is datastage?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?