21. Which technology should be used for interactive data querying across multiple dimensions for a decision making for a DW?
MOLAP
22. What is Virtual Data Warehousing?
A virtual or point-to-point data warehousing strategy means that end-users are allowed to get at operational databases directly using whatever tools are enabled to the "data access network"
23. What is the difference between metadata and data dictionary?
Meta data is nothing but information about data. It contains the information (i.e. data) about the graphs, its related files, abinitio commands, server information etc i.e. all kinds of information about project related information etc.
24. What is the difference between mapping parameter & mapping variable in data warehousing?
Mapping Parameter defines the constant value and it cannot change the value throughout the session.Mapping Variables defines the value and it can be change throughout the session
25. Explain the advantages of RAID 1, 1/0, and 5. what type of RAID setup would you put your TX logs.
The basic advantage of RAID is to speed up the data reading from permanent storage device (hard disk).
26. What are the Characteristics of Data Files?
A data file can be associated with only one database. Once created a data file can't change size. One or more data files form a logical unit of database storage called a table space.
27. What is Rollback Segment?
A Database contains one or more Rollback Segments to temporarily store "undo" information.
28. What is a Table space?
A database is divided into Logical Storage Unit called table spaces. A table space is used to grouped related logical structures together.
29. What is Database Link?
A database link is a named object that describes a "path" from one database to another.
30. What is a Private Synonyms?
A Private Synonyms can be accessed only by the owner.
Read More Questions:
Data Warehousing Interview Questions Part1
Data Warehousing Interview Questions Part2
Data Warehousing Interview Questions Part3
Data Warehousing Interview Questions Part4
MOLAP
22. What is Virtual Data Warehousing?
A virtual or point-to-point data warehousing strategy means that end-users are allowed to get at operational databases directly using whatever tools are enabled to the "data access network"
23. What is the difference between metadata and data dictionary?
Meta data is nothing but information about data. It contains the information (i.e. data) about the graphs, its related files, abinitio commands, server information etc i.e. all kinds of information about project related information etc.
24. What is the difference between mapping parameter & mapping variable in data warehousing?
Mapping Parameter defines the constant value and it cannot change the value throughout the session.Mapping Variables defines the value and it can be change throughout the session
25. Explain the advantages of RAID 1, 1/0, and 5. what type of RAID setup would you put your TX logs.
The basic advantage of RAID is to speed up the data reading from permanent storage device (hard disk).
26. What are the Characteristics of Data Files?
A data file can be associated with only one database. Once created a data file can't change size. One or more data files form a logical unit of database storage called a table space.
27. What is Rollback Segment?
A Database contains one or more Rollback Segments to temporarily store "undo" information.
28. What is a Table space?
A database is divided into Logical Storage Unit called table spaces. A table space is used to grouped related logical structures together.
29. What is Database Link?
A database link is a named object that describes a "path" from one database to another.
30. What is a Private Synonyms?
A Private Synonyms can be accessed only by the owner.
Read More Questions:
Data Warehousing Interview Questions Part1
Data Warehousing Interview Questions Part2
Data Warehousing Interview Questions Part3
Data Warehousing Interview Questions Part4
No comments:
Post a Comment