1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Source-staging-etl-datawarehouse

Discussion in 'SQL PL/SQL' started by Evolup, Oct 3, 2017.

  1. Evolup

    Evolup Starter

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    Nepal
    I would much appreciate to get an sample of data travelling via these steps.
    Source data to Staging server(tables) then PLSQL for data cleansing and transferring them to tbl_cleanABC or tbl_error_ABC. Checking the accuracy of data and finally PLSQL for loading to data warehouse

    the query of structure of table is given below as attached file
     

    Attached Files: