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.
Specify the vaious types of data warehouses?
Give a brief differentiation between metadata and data dictionary?
Explain terms Procedure Cache in Sybase. Answer: It is the memory area where compiled query tree run for example: procedure and batch query.
Describe briefly three types of binary relationships in DBMS?
Explain, why we use the lookup transformations?
How you can detect the loops?
Describe about generating a report tool by utilizing the report tool and the report wizard?
Explain the function of metadata for the three-layer architecture?
Illustrates the basic elements in ER models?
Illustrates the term update statistics in Sybase?
18,76,764
1949939 Asked
3,689
Active Tutors
1414670
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!