What is META DATA information in Data warehousing projects?
Answers were Sorted based on User's Feedback
Answer / maruthi
META-DATA-> DATA-ABOUT-DATA IN THE SENSE ETL REPOSITORIES
WILL STORE METADDATA OF ALL THE TABLES/SCHEMAS TO MPROCESS
DATA FROM SOURCE TO TARGET.SO IT WILL STORE THE TABLE
NAME ,COLUMN TYPE/LENGTH/NULL/KEY OR NOT IN SUCH A WAY
MATADATA WILL BE STORD IN ETL REPOSITORIES./
| Is This Answer Correct ? | 10 Yes | 3 No |
Answer / sekhar
a meta data is which can store in the repository using repository service
| Is This Answer Correct ? | 0 Yes | 0 No |
Whether dimension table can have numeric value?
What are the various methods of getting incremental records or delta records from the source systems?
Explain what type of indexing mechanism do we need to use for a typical datawarehouse?
What is BCP?
how do you use commit frequencies? how does it affect loading performance?
Why facts table is useful in representing the data?
What is prompt types of prompts?use of prompts syntax of prompt?
What is the difference between aggregate table and materialized view?
What is Active Datawarehousing?
What is analytical or analytic mean?
What is DTM session?
Name at least three brands of Database Management Systems