This discussion is archived
1 Reply Latest reply: Dec 7, 2012 5:01 AM by Srini VEERAVALLI RSS

Invremental load from OBIEE Datawarehouse.

AceNovice Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points