topic SAS DI : Data Management in SAS Data Management

SAS DI : Data Management

JJP1 — Tue, 30 Jul 2019 08:50:33 GMT

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

Re: SAS DI : Data Management

rajdeep — Mon, 12 Aug 2019 12:08:14 GMT

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.