Difference between ETL vs. ELT

 

Difference between ETL vs. ELT

BasicsETLELT
ProcessData is transferred to the ETL server and moved back to DB. High network bandwidth required.Data remains in the DB except for cross Database loads (e.g. source to object).
TransformationTransformations are performed in ETL Server.Transformations are performed (in the source or) in the target.
Code UsageTypically used for
  • Source to target transfer

  • Compute-intensive Transformations

  • Small amount of data
Typically used for
  • High amounts of data
Time-MaintenanceIt needs highs maintenance as you need to select data to load and transform.Low maintenance as data is always available.
CalculationsOverwrites existing column or Need to append the dataset and push to the target platform.Easily add the calculated column to the existing table.
AnalysisDifference between ETL and ELTDifference between ETL and ELT


Comments

Post a Comment

Popular posts from this blog

What is SSIS Container? Explain Different types of Containers in SSIS

Image
SSIS containers are defined as a set of logically linked tasks that allows the management of the task scope effectively. Containers allow looping through tasks set until tasks are grouped logically or until specified criteria are met. Nesting of containers is also allowed and the containers are set in the Package designer section in the Control flow tab.   The following containers are present in SSIS: Task Host Containers:  Default container where all single tasks are available and are used for background scenes in SSIS. This is not present in the toolbox of Visual Studio and is assigned to the task implicitly. This container is also used to extend event handlers and variables. Sequence Containers:  These handle the flow of package subset and helps to divide packages into smaller pieces. These are displayed in the Control Flow tab. We can drag and drop containers from the toolbox in the design pane and then add a set of tasks into the container. Following things can be ac...
Read more

What is Connection Mangers

  Connection as its name suggests is a component to connect to any source or destination from SSIS — like a sql server or flat file or lot of other options that SSIS provides. Connection manager is a logical representation of a connection. Connection Managers are used for gathering data from various sources and sending it to a destination. It facilitates system connection by including information regarding server, data source, authentication details, database, etc.
Read more