What is Aggregate Awareness
Explain the Aggregate Awareness?
Expert
Aggregate awareness refers to the characteristic of the DESIGNER which makes the use of aggregate tables within the database. These are tables which consist of the pre-calculated data. The aim of these tables is to improve the performance of the SQL transactions; they are therefore used in order to speed up the execution of queries.
Specify the several types of Strategies?
Differentiate between Multiload and Fastload in terms of Performance?
Explain the term iConv and oConv?
Name four applications which are employing for triggers in DBMS?
Explain how do you produce the Sequence number within the Data stage?
Describe briefly perform recovery?
Elucidate how can we get first 100 rows from flat file in the target?
Specify the enhancements which are made within datastage 7.5 and also compare with the 7.0?
Write a short on the differences of the two principal types of packaged data models.
How any Data Structure application is categorized among files?
18,76,764
1942928 Asked
3,689
Active Tutors
1416406
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!