SAS DI : Data Management

[JJP1]

Hi,
I need to build a SAS warehouse dataset and the source for this dataset will be oracle.
where in oracle update or inser or delete will be happening on daily basis or may not happen.
but i should consider all those cases and build the SAS jobs please.
Actually the source would be 3 oracle tables on which i need to join pleease.
for this iam thinking that we need to build one off and incremental jobs.
would you please provide your thoughts on this how to achive this please

[rajdeep]

Hi 

I think you need to perform a join with 3 tables and then one table loader and load the data based on the control table where you need to make something conditions based on the start and end date.

I hope you are aware about the control table parameters or else have a check with Google.

Because with SAS DI JOB design I might not help you from here.

Gud luck.