I have to Do few Source to Staging Transformations those are Derived Delta Stagey(CDC) ,
Ho can i do this in SAS DI 3.4, Because in 3.4 we do not have any Specific Data Transforms for CDC, BTW i am an Oracle ETL developer, not so Good at SAS DI , Please explain me in the way how can i understand (Thank you For your Kindness) - My Exposure to SAS DI is only one month.
So, it seems that have a defined column for last modification.
I suggest that you use a Pre-step to create macro variabl(-es) (perhaps based on a &SYSPARM value or some other logic) so that you can build a dynamic where clause in a SAS Extract object in the process flow.
Be aware of that Oracle DATE type will interpreted as SAS DATETIME (the time part will be padded as 0:00:00).
I do not have defined column for last modification in the Source Data?
More Over How can i DO this Pre-step to create macro variabl(-es) (perhaps based on a &SYSPARM value or some other logic) so that you can build a dynamic where clause in a SAS Extract object in the process flow
My experience is that is very hard (impossible?) to run a SAS DI project without having someone to some SAS programming tasks, such as this. I can try to tell you how to do this, but my guess is that you will run into new obstacles where you need to have some basic SAS programming skills. So try to involve a SAS programmer to this utility stuff in your ETL jobs.
First some basic knowledge on SAS in the operating environment, how start SAS in batch, system options, search paths etc.
For SAS programming, you will probably some here and there, how much depends on project size and level of difficulty (data, transformation rules, target model...). I should say 2-3 SAS programming classes to start with.