Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
  • What is ETL ?

    • 0
    • 2
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 335
    Comment on it

    Meaning Of ETL:-

    ETL,simple meaning of ETL is - Extract-Transform-Load. ETL is a procedure by which data or information is loaded from the source or origin system to the data warehouse. Data or information is removed from an OLTP database and then converted to correspond data warehouse schema and loaded into the data warehouse database.
    E - Extract
    T - Transform
    L - Load

    Extract:- The main purpose of this is, extract to the relevant data. Or extract information or data from the source or origin system.

    Transform:- The main purpose of this is, transform or change the data to data warehouse format. Or use functions to fulfill data to an established dimensional schema.

    Load:- The main purpose of this is, load the data into the data mart for exhaustion Or load data into data warehouse.

 0 Comment(s)

Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: