Increasing the performace in the Data Stage
How can we increase the performance within the Data Stage?
Expert
In the server canvas we may increase the performance in two ways: a) Firstly, we can improve the memory by allowing the inter process row buffering within the job properties b) Secondly, by inserting the IPC stage we break the process into two processes. We may use this stage in order to connect the two passive stages or the two active stages.
Describe briefly the term SQL Server Analysis Services cubes?
Briefly describe the employ of aggregate tables and lookup tables?
Illustrate briefly the term insertion and deletion anomalies?
Define the way of passing of variables to a SQL routine.
Explain, why we use the lookup transformations?
Illustrate the term data mart. What do you mean by it?
Specify the various types of Aggregation?
To perform recursion which data structures is used?
Briefly describe the differentiation between data warehouse and OLAP?
Illustrates the cold backup in case of Oracle?
18,76,764
1944636 Asked
3,689
Active Tutors
1441942
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!