Answer Posted / madhu
any yes or no like status is an example for junk dimension
| Is This Answer Correct ? | 11 Yes | 8 No |
Post New Answer View All Answers
Explain what are slowly changing dimensions?
Explain hybrid slowly changing dimension?
Explain what is the difference between powerplay transformer and power play reports?
What is a source qualifier?
Explain what is batch and describe about types of batches?
What is a data profile?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?
What is crass reference table?
What are the design methods of data warehousing?
What are data validation strategies for data mart validation after loading process?
Explain why should you put your data warehouse on a different system than your oltp system?
How to load the time dimension?
what are different storage options supported by oracle ?
Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?