Click here to Skip to main content
12,697,190 members (26,237 online)
   

Database

 
AnswerRe: DATABASE QUESTIOM Pin
Eddy Vluggen18-Nov-12 12:23
memberEddy Vluggen18-Nov-12 12:23 
QuestionMS SQL - Tinyint - Default Value Pin
JammoD8716-Nov-12 3:56
memberJammoD8716-Nov-12 3:56 
AnswerRe: MS SQL - Tinyint - Default Value Pin
J4amieC16-Nov-12 4:08
memberJ4amieC16-Nov-12 4:08 
AnswerRe: MS SQL - Tinyint - Default Value Pin
Mycroft Holmes16-Nov-12 16:11
memberMycroft Holmes16-Nov-12 16:11 
GeneralRe: MS SQL - Tinyint - Default Value Pin
jschell17-Nov-12 7:29
memberjschell17-Nov-12 7:29 
GeneralRe: MS SQL - Tinyint - Default Value Pin
Mycroft Holmes17-Nov-12 16:06
memberMycroft Holmes17-Nov-12 16:06 
AnswerRe: MS SQL - Tinyint - Default Value Pin
JammoD8716-Nov-12 23:30
memberJammoD8716-Nov-12 23:30 
QuestionStaging Area Pin
Phanindra26115-Nov-12 10:05
memberPhanindra26115-Nov-12 10:05 
AnswerRe: Staging Area Pin
mark merrens15-Nov-12 10:37
membermark merrens15-Nov-12 10:37 
GeneralRe: Staging Area Pin
Phanindra26116-Nov-12 1:14
memberPhanindra26116-Nov-12 1:14 
GeneralRe: Staging Area Pin
mark merrens16-Nov-12 8:58
membermark merrens16-Nov-12 8:58 
QuestionRe: Staging Area Pin
Phanindra26116-Nov-12 9:11
memberPhanindra26116-Nov-12 9:11 
AnswerRe: Staging Area Pin
mark merrens16-Nov-12 9:34
membermark merrens16-Nov-12 9:34 
AnswerRe: Staging Area Pin
Mycroft Holmes16-Nov-12 16:20
memberMycroft 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 Pin
S Douglas27-Nov-12 20:38
memberS Douglas27-Nov-12 20:38 
GeneralRe: Staging Area Pin
Mycroft Holmes27-Nov-12 21:31
memberMycroft Holmes27-Nov-12 21:31 
GeneralRe: Staging Area Pin
S Douglas29-Nov-12 8:52
memberS Douglas29-Nov-12 8:52 
Questionfirst linq for entity frame work? Pin
Member 875182715-Nov-12 2:02
memberMember 875182715-Nov-12 2:02 
AnswerRe: first linq for entity frame work? Pin
digimanus15-Nov-12 4:17
memberdigimanus15-Nov-12 4:17 
QuestionBEGIN TRANSACTION AND COMMIT TRANSACTION Pin
vanikanc14-Nov-12 8:40
membervanikanc14-Nov-12 8:40 
AnswerRe: BEGIN TRANSACTION AND COMMIT TRANSACTION Pin
Phanindra26114-Nov-12 9:40
memberPhanindra26114-Nov-12 9:40 
QuestionFault Exception in WCF Services Pin
Phanindra26114-Nov-12 7:15
memberPhanindra26114-Nov-12 7:15 
AnswerRe: Fault Exception in WCF Services Pin
Eddy Vluggen14-Nov-12 7:36
memberEddy Vluggen14-Nov-12 7:36 
GeneralRe: Fault Exception in WCF Services Pin
Phanindra26114-Nov-12 9:05
memberPhanindra26114-Nov-12 9:05 
QuestionRelation multiple table using in C# Pin
YBG13-Nov-12 3:53
memberYBG13-Nov-12 3:53 
AnswerRe: Relation multiple table using in C# Pin
Phanindra26114-Nov-12 9:23
memberPhanindra26114-Nov-12 9:23 
QuestionTrying to get a MySQL subquery to return multiple records Pin
SQL Ed12-Nov-12 9:19
memberSQL Ed12-Nov-12 9:19 
AnswerRe: Trying to get a MySQL subquery to return multiple records Pin
Eddy Vluggen12-Nov-12 12:33
memberEddy Vluggen12-Nov-12 12:33 
QuestionSending data to database Pin
Phanindra26111-Nov-12 20:03
memberPhanindra26111-Nov-12 20:03 
AnswerRe: Sending data to database Pin
jschell12-Nov-12 11:08
memberjschell12-Nov-12 11:08 
AnswerRe: Sending data to database Pin
Mycroft Holmes12-Nov-12 13:51
memberMycroft Holmes12-Nov-12 13:51 
GeneralRe: Sending data to database Pin
Phanindra26113-Nov-12 19:40
memberPhanindra26113-Nov-12 19:40 
QuestionHow to create reports effectively Pin
Frygreen9-Nov-12 1:52
memberFrygreen9-Nov-12 1:52 
AnswerRe: How to create reports effectively Pin
David Mujica9-Nov-12 3:32
memberDavid Mujica9-Nov-12 3:32 
AnswerRe: How to create reports effectively Pin
Mycroft Holmes9-Nov-12 5:08
memberMycroft Holmes9-Nov-12 5:08 
AnswerRe: How to create reports effectively Pin
Frygreen9-Nov-12 5:10
memberFrygreen9-Nov-12 5:10 
Suggestionsql server 2008 security Pin
Member 36227527-Nov-12 9:00
memberMember 36227527-Nov-12 9:00 
GeneralRe: sql server 2008 security Pin
Mycroft Holmes7-Nov-12 12:27
memberMycroft Holmes7-Nov-12 12:27 
GeneralRe: sql server 2008 security Pin
jschell8-Nov-12 9:56
memberjschell8-Nov-12 9:56 
QuestionHelp me my Sql expired Pin
mehdi_nassiri00986-Nov-12 11:03
membermehdi_nassiri00986-Nov-12 11:03 
AnswerRe: Help me my Sql expired Pin
Jörgen Andersson6-Nov-12 11:22
memberJörgen Andersson6-Nov-12 11:22 
AnswerRe: Help me my Sql expired Pin
Joy Sinha22-Nov-12 21:09
memberJoy Sinha22-Nov-12 21:09 
QuestionADO.NET Pin
M.T.H.Danish6-Nov-12 7:25
memberM.T.H.Danish6-Nov-12 7:25 
AnswerRe: ADO.NET Pin
Richard MacCutchan6-Nov-12 8:28
mvpRichard MacCutchan6-Nov-12 8:28 
AnswerRe: ADO.NET Pin
Eddy Vluggen6-Nov-12 10:18
memberEddy Vluggen6-Nov-12 10:18 
GeneralADO.NET Pin
M.T.H.Danish6-Nov-12 7:11
memberM.T.H.Danish6-Nov-12 7:11 
AnswerRe: ADO.NET Pin
ihoecken6-Nov-12 7:27
memberihoecken6-Nov-12 7:27 
QuestionSQL SERVER 2008 Pin
M.T.H.Danish6-Nov-12 3:49
memberM.T.H.Danish6-Nov-12 3:49 
AnswerRe: SQL SERVER 2008 Pin
David Mujica6-Nov-12 4:27
memberDavid Mujica6-Nov-12 4:27 
AnswerRe: SQL SERVER 2008 Pin
J4amieC6-Nov-12 4:31
memberJ4amieC6-Nov-12 4:31 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    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
Web02 | 2.8.170118.1 | Last Updated 20 Jan 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid