Timeline for Methodology & Architecture to Create ETL Process
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 17, 2012 at 10:34 | history | tweeted | twitter.com/#!/StackDBAs/status/214305132811255808 | ||
| Jun 14, 2012 at 15:23 | comment | added | AmmarR | for "designing an ETL process regardless of the tool" , books or courses by Ralph Kimball very useful for generic concepts just like @Codek & @N West suggested, you also have the TDWI search for ETL papers. --- point 2 to use sql code only, Linked servers & Openquery will help you transfer Data to SQL with sql code only | |
| Jun 14, 2012 at 15:01 | comment | added | HelloWorld1 | The answer is "designing an ETL process regardless of the tool". I would like to use sql code only, no ETL application like SSIS or Informatica. | |
| Jun 14, 2012 at 14:55 | answer | added | Codek | timeline score: 4 | |
| Jun 14, 2012 at 14:12 | comment | added | AmmarR | are you looking for a generic way, i mean designing an ETL process regardless of the tool or you want to develop an ETL package of a specific tool, because every tool is different and in your case you mentioned sqlserver as a tag, so you might be looking for DTS sql 2000 or SSIS sql 2005 & above | |
| Jun 14, 2012 at 7:54 | history | asked | HelloWorld1 | CC BY-SA 3.0 |