Repository Tables in the Data Stage
Explain the term Repository Tables within the Data Stage?
Expert
a) A data ware house is defined as the repository, centralized as well as distributed, of the Data, which is capable to answer any analytical, adhoc, historical or the complex queries.
b) Metadata is described as the data about data.
c) The repository environment includes all the corporate metadata resources: data dictionaries, database catalogs, and the navigation services. Metadata involves things such as the length, name, valid values, and the description of the data element.
d) Metadata is generally stored within the data dictionary and repository.
What is OLAP? Briefly define it.
Define the class?
Explain the term Data mart?
What the difference between sequential file stage and hashed file stage is in relates to DataStage Server?
What are the utilities Oracle gives, which are utilize for backup and recovery?
Categorize the Hashing Functions based on the different methods through which the key value is found?
Describe the process that takes place to execute a stored routine.
Give a brief introduction of the term data cleaning?
Write down a short note on the functions of a reporting system?
Specify the types of connections we use while connecting with the database?
18,76,764
1932522 Asked
3,689
Active Tutors
1416123
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!