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.
Explain the Data Transformation Manager (DTM)?
Explain the way to support Row Level Locking in Sybase.
Specify the types of join that are available?
Describe the term HOLAP.
Write down the differentiation between view and materialized view?
Explain Triggers and Rules?
hatcher also created the accompanying Level 1 data flow diagram for this process. Unfortunately, this DFD has numerous syntax and semantic errors. Identify the errors. Redraw the DFD to more correctly represent the receive supplier shipments process.
Illustrate the difference between the data warehousing and OLAP?
State the benefits of the Business Objects over the other DSS?
Explain in brief the term apex cuboids.
18,76,764
1960435 Asked
3,689
Active Tutors
1439347
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!