Where can one get more info about Data Warehousing?
Answer Posted / tanmay kumar meher
I think, the book ?Data Warehousing Tool Kit" by R.Kimbal
is the best one to have information about data warehousing.
It has got a very generic way of stepping in to
fundamentals of Data Warehousing and the process to build a
data warehouse.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Explain what is the limit to the number of sources and targets you can have in a mapping?
Where we use surrogate key explain with example?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
What is the difference between power center and power mart?
Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?
What are the various methods of getting incremental records or delta records from the source systems?
Explain what is partitioning? What are the types of partitioning?
How would you declare an inline css to format the table with a background color of yellow and give the table cell a right margin of 10 pixels?
What is conformed fact?
Which columns go to the fact table and which columns go the dimension table?
Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?
What are the different problems that ?Data mining? can solve?
What we will do with the universe for faster process?
What is a core dimension?
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.