1 Reply Latest reply: Dec 7, 2012 7:01 AM by Srini VEERAVALLI RSS

    Invremental load from OBIEE Datawarehouse.

    AceNovice
      Hi All,

      Our source is a OBIEE Warehouse (Financila Analytics and Real Estate). We need to fetch incremental load from the Dimension Table. I am not able to understand which column i should use, which gives me updated records as well as newly inserted records in the Dimension table of Warehouse table.

      For example, I have checked W_INT_ORG D table. I found Below columns
      CREATED_BY_WID, 
      CHANGED_BY_WID, 
      CREATED_ON_DT, 
      CHANGED_ON_DT, 
      AUX1_CHANGED_ON_DT, 
      AUX2_CHANGED_ON_DT, 
      W_INSERT_DT, 
      W_UPDATE_DT, 
      After my preliminary analysis, i found thet if i use W_INSERT_DT and W_UPDATE_DT, it will server my purpose as remaining columns are Source Specific (gives information on when the record in source was created or updated)

      My query would be
      SELECT * FROM W_INT_ORG_D
      WHERE W_INSERT_DT > {previosus_load_dt} OR W_UPDATE_DT > {previous_load_dt}.
      But i am not sure if this is correct or not. Appreciate if someone can help me to write a correct WHERE condition.