What is a staging area? Do we need it? What is the purpose of a staging area?
No Answer is Posted For this Question
Be the First to Post Answer
How are the dimension tables designed?
What are the advantages of query studio compared to report studio?
what is indexing ? what are different types of indexes supported by oracle ?
What is the difference between dependent data warehouse and independent data warehouse?
Explain ddl (data definition language)?
What is is a star schema?
How can we transform row to column?
Explain the process of extracting data from source systems,storing in ods and how data modeling is done?
Difference between e-r modeling and dimentional modeling?
What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?
Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.
Name a few sectors which use data warehousing?