This is an excellent example on Partition Switching - very thorough and an example that didn't bring in other complexities that cloud the example of partition creation and switching. Thanks!
7 years late to the party, but in your large update scenario, I assume you are talking about accumulating snapshot facts (Kimball) or slowly changing facts (someone else who I won't mention)?
Good question- I’d want to say it could be both scenarios- his was more so establishing how the fact and switch table has data they ingested and the deltas didn’t show until you swapped the schemas
This is an excellent example on Partition Switching - very thorough and an example that didn't bring in other complexities that cloud the example of partition creation and switching. Thanks!
I realize it's pretty off topic but does anyone know a good place to watch newly released movies online?
@Antonio Demetrius I would suggest flixzone. You can find it by googling =)
@Maximilian Julian definitely, been using Instaflixxer for since april myself =)
7 years late to the party, but in your large update scenario, I assume you are talking about accumulating snapshot facts (Kimball) or slowly changing facts (someone else who I won't mention)?
Good question- I’d want to say it could be both scenarios- his was more so establishing how the fact and switch table has data they ingested and the deltas didn’t show until you swapped the schemas
Nice one..!
13:42