Utilization of HASH file
Explain how is the HASH file used and where we can use it?
Expert
HASH file is generally used for the Lookup where as the populating fact table keeps the data within the buffer and utilize the Hashing algorithm that improves the performance of the job. It utilizes the GENERAL or SEQ.NUM algorithm.
Explain the term local container and shared container?
Describe the inconsistent values problem? Comprise an appropriate example?
Explain the term optimization and performance tuning and its work in practical projects?
What do you understand by the term SQL view in DBMS? Briefly describe the utilization of views?
Explain offline /online modes in the Designer?
How can we increase the performance within the Data Stage?
How must you modify the function to handle error?
Give a brief introduction of the term data mining and data modeling? In what manner both the termed are used?
What do you understand by the term denormalization and why would someone consider doing so?
Explain the way of establishing connection by ODBC.
18,76,764
1956526 Asked
3,689
Active Tutors
1460559
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!