Tag Info

New answers tagged

0

While in a traditional OLTP system you may need to be concerned about normalizing and inheritance, in a typical data warehouse system you will want to denormalize to accelerate query responses. In this case, I would design an Employee_Dimension table which had all relevant columns about an employee which you might want to query against, along with an ...


0

SQLish Honestly, your best bet is probably ANSI-compliant SQL, because it can eliminate the ambiguities which you've mentioned. If there's any trouble with it needing to be written in "natural language", just add in the apprpriate prepositions and such... Select the maximum paid amount, the customer account number, and the customer phone number from the ...


0

Your question is vague, but here is a blog post from Matt Masson on how to get started with CDC and SSIS http://www.mattmasson.com/2011/12/cdc-in-ssis-for-sql-server-2012-2/


1

It's hard to give you a specific guidance on your best setup, but in any case there is no such thing as a trigger writing to an OLAP cube. I can give you some starting points though. You need to look into different storage options for your cubes. By default cubes use MOLAP (Multidimensional OLAP) in which you process a cube on a scheduled basis[1] and ...


7

These terms are not new to SQL 2016, but they are also not server roles as far as I know. For all i know these are pre-built Parallel Data Warehouse resource classes. There isn't much documentation on that except some blog posts. Have a look at these PDW, Integration Services and Resource Classes A teched presentation from Channel 9 I only heard about ...



Top 50 recent answers are included