Different methods of loading Dimension tables
Describe briefly the different methods of loading Dimension tables?
Expert
The methods to load Dimension tables are illustrated below:
i) Conventional load :- in this the data is determined for any table constraints ere loading.
ii) Direct or Faster load :- The data is straightly loaded with no checking for any constraints.
Explain the Hash file and the Sequential File?
Elucidate briefly power center repository?
Explain, what are Dimensional table?
What is meant by the parameter file?
Illustrates the way to assign an address to an element of a pointer array? Answer: We can assign a memory address to an element of an array of pointers by usin
Explain the relationship between JDBC and Sybase.
Give brief introduction of the term ‘Service Broker components’?
Explain the operations that can be done with the Data Stage Director?
Specify the several types of Strategies?
Specify the various types of Aggregation?
18,76,764
1931410 Asked
3,689
Active Tutors
1440722
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!