Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: JBroadwater
- Order by date
-
Incremental Load
Thanks. Yes, I take your point. I did leave out one part of my architecture/design that is significant: I only copy/move parts(partitions) of my stage area tables to the presentation area. But the copies to the presentation area are unequivocally purge and replace. I gather it is common then...- JBroadwater
- Post #5
- Forum: Data Warehousing/Big Data
-
"What a nonsense and waste of time and money, all that modeling"
Reasons to follow or not follow the users suggested solution: To follow: the user knows how to generate her own reports and knows the pitfalls of putting unscrubbed, nonconformed data/tables in her datamart, and all other users are similarly knowledgeable. To not follow: you know more than the...- JBroadwater
- Post #5
- Forum: Data Warehousing/Big Data
-
Incremental Load
Thank you RiverGuy. I do not rebuild entire dimensions or facts for each load. I do however keep 2 copies of dimensions and facts: one copy in a staging area which is off limits to end users, and a second copy in a presentation area which is available to end users. Perhaps I should have asked...- JBroadwater
- Post #3
- Forum: Data Warehousing/Big Data
-
Incremental Load
I initially understood Load (the L part of ETL -- Extract, Transform, Load) to mean copying prepared (complete, not partial) fact+dimension tables from a stage area to a presentation area. However, the concept of an incremental Load, appears to conflict with this understanding. I.e. you can...- JBroadwater
- Thread
- Replies: 7
- Forum: Data Warehousing/Big Data
