Click here to Skip to main content
       

Database

 
AnswerRe: DATABASE QUESTIOM PinmemberEddy Vluggen18-Nov-12 12:23 
QuestionMS SQL - Tinyint - Default Value PinmemberJammoD8716-Nov-12 3:56 
AnswerRe: MS SQL - Tinyint - Default Value PinmemberJ4amieC16-Nov-12 4:08 
AnswerRe: MS SQL - Tinyint - Default Value PinmemberMycroft Holmes16-Nov-12 16:11 
GeneralRe: MS SQL - Tinyint - Default Value Pinmemberjschell17-Nov-12 7:29 
GeneralRe: MS SQL - Tinyint - Default Value PinmemberMycroft Holmes17-Nov-12 16:06 
AnswerRe: MS SQL - Tinyint - Default Value PinmemberJammoD8716-Nov-12 23:30 
QuestionStaging Area PinmemberPhanindra26115-Nov-12 10:05 
AnswerRe: Staging Area Pinmembermark merrens15-Nov-12 10:37 
GeneralRe: Staging Area PinmemberPhanindra26116-Nov-12 1:14 
GeneralRe: Staging Area Pinmembermark merrens16-Nov-12 8:58 
QuestionRe: Staging Area PinmemberPhanindra26116-Nov-12 9:11 
AnswerRe: Staging Area Pinmembermark merrens16-Nov-12 9:34 
AnswerRe: Staging Area PinmemberMycroft Holmes16-Nov-12 16:20 
We do it somewhat different to Mark, our staging table are exact replicas of the source data, this allows us to use Bulk Copy when loading the data. It also insures there are no errors in the Load part of the ELT process.
 
We then use stored procedures to do the transforms to the production format (these may also be staging tables in some solutions). The major benefit is that you are doing any transforms on a limited data set and it is easy to debug the procedure. It then becomes a simple matter to dump in the staging data to the production tables.
 
I find a well crafted ELT process leave any ETL application in the dust. There are some ETL apps that this may not apply to but the cost is extraordinary.
Never underestimate the power of human stupidity
RAH

GeneralRe: Staging Area PinmemberS Douglas27-Nov-12 20:38 
GeneralRe: Staging Area PinmemberMycroft Holmes27-Nov-12 21:31 
GeneralRe: Staging Area PinmemberS Douglas29-Nov-12 8:52 
Questionfirst linq for entity frame work? PinmemberMember 875182715-Nov-12 2:02 
AnswerRe: first linq for entity frame work? Pinmemberdigimanus15-Nov-12 4:17 
QuestionBEGIN TRANSACTION AND COMMIT TRANSACTION Pinmembervanikanc14-Nov-12 8:40 
AnswerRe: BEGIN TRANSACTION AND COMMIT TRANSACTION PinmemberPhanindra26114-Nov-12 9:40 
QuestionFault Exception in WCF Services PinmemberPhanindra26114-Nov-12 7:15 
AnswerRe: Fault Exception in WCF Services PinmemberEddy Vluggen14-Nov-12 7:36 
GeneralRe: Fault Exception in WCF Services PinmemberPhanindra26114-Nov-12 9:05 
QuestionRelation multiple table using in C# PinmemberYBG13-Nov-12 3:53 
AnswerRe: Relation multiple table using in C# PinmemberPhanindra26114-Nov-12 9:23 
QuestionTrying to get a MySQL subquery to return multiple records PinmemberSQL Ed12-Nov-12 9:19 
AnswerRe: Trying to get a MySQL subquery to return multiple records PinmemberEddy Vluggen12-Nov-12 12:33 
QuestionSending data to database PinmemberPhanindra26111-Nov-12 20:03 
AnswerRe: Sending data to database Pinmemberjschell12-Nov-12 11:08 
AnswerRe: Sending data to database PinmemberMycroft Holmes12-Nov-12 13:51 
GeneralRe: Sending data to database PinmemberPhanindra26113-Nov-12 19:40 
QuestionHow to create reports effectively [modified] PinmemberFrygreen9-Nov-12 1:52 
AnswerRe: How to create reports effectively PinmemberDavid Mujica9-Nov-12 3:32 
AnswerRe: How to create reports effectively PinmemberMycroft Holmes9-Nov-12 5:08 
AnswerRe: How to create reports effectively PinmemberFrygreen9-Nov-12 5:10 
Suggestionsql server 2008 security PinmemberMember 36227527-Nov-12 9:00 
GeneralRe: sql server 2008 security PinmemberMycroft Holmes7-Nov-12 12:27 
GeneralRe: sql server 2008 security Pinmemberjschell8-Nov-12 9:56 
QuestionHelp me my Sql expired Pinmembermehdi_nassiri00986-Nov-12 11:03 
AnswerRe: Help me my Sql expired PinmemberJörgen Andersson6-Nov-12 11:22 
AnswerRe: Help me my Sql expired PinmemberJoy Sinha22-Nov-12 21:09 
QuestionADO.NET PinmemberM.T.H.Danish6-Nov-12 7:25 
AnswerRe: ADO.NET PinmvpRichard MacCutchan6-Nov-12 8:28 
AnswerRe: ADO.NET PinmemberEddy Vluggen6-Nov-12 10:18 
GeneralADO.NET PinmemberM.T.H.Danish6-Nov-12 7:11 
AnswerRe: ADO.NET Pinmemberihoecken6-Nov-12 7:27 
QuestionSQL SERVER 2008 PinmemberM.T.H.Danish6-Nov-12 3:49 
AnswerRe: SQL SERVER 2008 PinmemberDavid Mujica6-Nov-12 4:27 
AnswerRe: SQL SERVER 2008 PinmemberJ4amieC6-Nov-12 4:31 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web04 | 2.8.141216.1 | Last Updated 19 Dec 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid