In computing, extract, transform, load (ETL) is the general procedure of copying data from one or more sources into a destination system which represents the data differently from the source(s) or in a different context than the source(s). The ETL process became a popular concept in the 1970s and is often used in data warehousing.Data extraction involves extracting data from homogeneous or heterogeneous sources; data transformation processes data by data cleansing and transforming them into a proper storage format/structure for the purposes of querying and analysis; finally, data loading describes the insertion of data into the final target database such as an operational data store, a data mart, data lake or a data warehouse.A properly designed ETL system extracts data from the source systems, enforces data quality and consistency standards, conforms data so that separate sources can be used together, and finally delivers data in a presentation-ready format so that application developers can build applications and end users can make decisions.Since the data extraction takes time, it is common to execute the three phases in parallel. While the data is being extracted, another transformation process executes while processing the data already received and prepares it for loading while the data loading begins without waiting for the completion of the previous phases.
ETL systems commonly integrate data from multiple applications (systems), typically developed and supported by different vendors or hosted on separate computer hardware. The separate systems containing the original data are frequently managed and operated by different employees. For example, a cost accounting system may combine data from payroll, sales, and purchasing.

View More On Wikipedia.org
  1. Koda

    No load data_ what to do?

    Has anyone ever worked up a load with no published load data? Did you use a closest match (published data) and cautiously start at the bottom stopping at pressure or desired node? Long version: I wanted to try the 143g Lever Hammer bullet with my supply of Hornady Leverrevolution powder but...
  2. Koda

    30-30 Winchester Load Data

    So I ordered some Barnes TSX 150g flat nose monolithics but the only powder I have on hand that I can find 30-30 load data for is Accurate 2520 but Lees book shows this for a 150gr copper jacket bullet.... Is it safe to use load data for a different type of bullet but same weight? And if not...
  3. Grendelhunter

    7.62x39 subsonic load data......

    Looking to do some sub loads in 7.62x39. not finding much info. What say you all?????
  4. arakboss

    Dangers using cast load data for plated or fmj rifle bullet reduced loads.

    This youtuber thinks it's ok to use cast load data for reduced loads with FMJ rifle bullets. Anybody here disagree, if so why? Anybody done this what were your results? Skip to 15:20 mark for discussion about using FMJ with reduced cast load data.
  5. Vorpalis

    8.6 Creedmoor: Looking for chamber, cartridge dimensions, and load data

    This is a long shot, but does anyone know where I might find chamber and cartridge dimensions, as well as load data for the upcoming 8.6 Creedmoor cartridge? I heard the spec has been finalized, and that Hornady has the data available, but it's not on their website, and when I asked them they...
  6. Knebel

    Question about Max load data with Trailboss

    I am aiming to load some 440 grain 500 s&w to archieve at leats 1000 to 1100fps. That would give me roughly 1000footpounds. The projectiles I have have a gas seal.. So I found this load data and I am curious... why is the MAX so low when its around 20000psi? The 500 can handle 50k psi!? I have...
  7. Koda

    Exploring the upper limits of load data

    25-06, 120gr Nosler partition, IMR4831.... use: hunting round. Lee, and IMR load data tops out at 53gr. I'm getting good groups 52gr up to 52.6gr but haven't gone above 52.6gr but just shy of what I was hoping for so I want to squeeze more velocity if possible so I'm undecided on my next load...
  8. G

    Looking for Load data for Bear Creek 96g rn in 38 sp

    Looking to make a 38 special load comparable to the Hornady 90grain FTX Critical defense “Lite” load Using some Bear creek .358 96g round nose I bought from a member. These will allow my wife to make her LCR go bang at a reasonable cost!! Anyone have a tried and true load recipe for such a...
  9. O

    300winmag load data whats ur favorite

    So wanna load some 300winmag pefer 180-200 was curious whats everyone's favorite load Thanks
  10. KAMIKAZE BOB

    Load Data for AMT/IAI Automag IV 45 Win Mag

    Does anyone have any success at reloading for the IAI/AMT Automag IV in 45 Win Mag? FYI-were not talking about the Auto Mag (of the Dirty Harry fame). It's commonly known to Automag shooters, these pistols experience numerous (and various types) malfunctions. I've been trying to find to most...
Back Top