Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
CoffeeAddict
Yak Posting Veteran
94 Posts |
 Posted - 2012-08-12 : 23:33:16
|
| Ok I'm on a project where I'm really an App Developer that's been put on a BI project for a new data warehouse to be created.Right now I'm trying to dive head first into SSIS. I need to perform CRUDs that take data from x tables in one database and port them into import tables I've created in a new database that will serve as the data warehouse.I'm looking at SSIS and know I probably need transforms to do stuff like Add/Delete/Update to my import tables based on the data I'm grabbing from the source database. For example if records are deleted form the source table in my SSIS data flow I need to be able to check for that and mark them deleted in my destination table (soft delete) in my data warehouse.I have no clue how to start doing that sort of logic especially how to grasp the concept of how a star schema works and how a basic star schema is created in SSIS. So what resources would you recommend to get me there fastest, to understand SSIS quickly and just be able to do basics such as again, detecting differences in data sets so I can determine whether to delete, update, or add new records to my import table to sync the source DB with my warehouse import tables.Crazy, I have like no time and I'm building this crap out. |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
|
|
|
|
|
New to SSIS and BI - Just been tasked with ETL