Click here to Skip to main content
15,911,317 members
Home / Discussions / Design and Architecture
   

Design and Architecture

 
QuestionIt's mediators all the way down. Pin
Leslie Sanford10-Aug-11 4:48
Leslie Sanford10-Aug-11 4:48 
AnswerRe: It's mediators all the way down. Pin
Pete O'Hanlon10-Aug-11 4:53
mvePete O'Hanlon10-Aug-11 4:53 
AnswerRe: It's mediators all the way down. Pin
jschell10-Aug-11 9:59
jschell10-Aug-11 9:59 
QuestionGeneral Architecture query - SSIS / XML / BizTalk [modified] Pin
bgallagher_lib2-Aug-11 22:18
bgallagher_lib2-Aug-11 22:18 
AnswerRe: General Architecture query - SSIS / XML / BizTalk Pin
jschell3-Aug-11 10:16
jschell3-Aug-11 10:16 
GeneralRe: General Architecture query - SSIS / XML / BizTalk Pin
bgallagher_lib4-Aug-11 1:22
bgallagher_lib4-Aug-11 1:22 
GeneralRe: General Architecture query - SSIS / XML / BizTalk Pin
jschell4-Aug-11 8:16
jschell4-Aug-11 8:16 
AnswerRe: General Architecture query - SSIS / XML / BizTalk Pin
Mycroft Holmes4-Aug-11 3:05
professionalMycroft Holmes4-Aug-11 3:05 
F***ing ETL, whoever put the transform in ETL should be taken out and shot.
Load the data into a staging table that exactly reflects the source data, NO transforms, no data types, make all the fields varchar(###) big enough to service your data fields.

Now you have the data in a platform that is designed to manipulate data. Write a stored procedure that transforms the data from the staging table to your target table. This gives you a fast, repeatable process that you can manage in TSQL not some obscure data/row/field/column transform object in your ETL tool. If you don't have TSQL skills then hire someone who does, they are not uncommon.

BizTalk, and every other transform tool I have ever had to use are garbage, I can write a bulk copy and stored procedure process that will out perform them every time. The only tool that came close to performance equality has been Informatica that will cost you $100k+ to implement.
Never underestimate the power of human stupidity
RAH

GeneralRe: General Architecture query - SSIS / XML / BizTalk Pin
bgallagher_lib4-Aug-11 3:37
bgallagher_lib4-Aug-11 3:37 
GeneralRe: General Architecture query - SSIS / XML / BizTalk Pin
S Douglas25-Aug-11 15:28
professionalS Douglas25-Aug-11 15:28 
QuestionMaster / Detail Datasource design quesiton Pin
David Mujica12-Jul-11 10:47
David Mujica12-Jul-11 10:47 
AnswerRe: Master / Detail Datasource design quesiton Pin
jschell12-Jul-11 10:56
jschell12-Jul-11 10:56 
GeneralRe: Master / Detail Datasource design quesiton Pin
David Mujica13-Jul-11 3:29
David Mujica13-Jul-11 3:29 
GeneralRe: Master / Detail Datasource design quesiton Pin
jschell13-Jul-11 9:00
jschell13-Jul-11 9:00 
GeneralRe: Master / Detail Datasource design quesiton Pin
Mycroft Holmes4-Aug-11 3:13
professionalMycroft Holmes4-Aug-11 3:13 
GeneralRe: Master / Detail Datasource design quesiton Pin
may esguerra22-Aug-11 5:34
may esguerra22-Aug-11 5:34 
AnswerRe: Master / Detail Datasource design quesiton Pin
Nagy Vilmos2-Aug-11 22:41
professionalNagy Vilmos2-Aug-11 22:41 
GeneralThank you Pin
David Mujica3-Aug-11 5:18
David Mujica3-Aug-11 5:18 
QuestionIntegrate CAS and ADFS Pin
_Zorro_9-Jun-11 0:18
professional_Zorro_9-Jun-11 0:18 
QuestionWriting Windows Service to connect to Visual Source Safe and download the code Pin
meeram3952-Jun-11 23:40
meeram3952-Jun-11 23:40 
AnswerRe: Writing Windows Service to connect to Visual Source Safe and download the code Pin
Eddy Vluggen3-Jun-11 0:11
professionalEddy Vluggen3-Jun-11 0:11 
GeneralRe: Writing Windows Service to connect to Visual Source Safe and download the code Pin
meeram3953-Jun-11 0:19
meeram3953-Jun-11 0:19 
GeneralRe: Writing Windows Service to connect to Visual Source Safe and download the code Pin
JV999916-Jun-11 3:27
professionalJV999916-Jun-11 3:27 
QuestionMicrosoft Application Architecture Guide Pin
V.23-May-11 3:31
professionalV.23-May-11 3:31 
AnswerRe: Microsoft Application Architecture Guide Pin
Groulien23-May-11 3:45
Groulien23-May-11 3:45 

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.