Help using Base SAS procedures

How can i Do the CDC in SAS DI 3.4?

Reply
N/A
Posts: 0

How can i Do the CDC in SAS DI 3.4?

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.

TIA - SASBaby Message was edited by: SASbaby
Super User
Posts: 5,428

Re: How can i Do the CDC in SAS DI 3.4?

Posted in reply to deleted_user
You have to describe in more detail how your Derived Delta Strategy will work, on a higher level. Is your source Oracle? Will there be logging, or some timestamps in the source tables?

Without this information, is not possible to help you out with DI Studio details.

Regards, Linus
Data never sleeps
N/A
Posts: 0

Re: How can i Do the CDC in SAS DI 3.4?

Source FieldS:

CAR_KIND_ID CHAR(2)
DESCRIPTION VARCHAR2(254)
MOD_BY VARCHAR2(60)
MOD_DATE DATE


Target Fields:

ALTER_TS TIMESTAMP(6)
UPDATE_TYPE CHAR(1)
CAR_KIND_ID CHAR(2)
DESCRIPTION VARCHAR2(254)
MOD_BY VARCHAR2(60)
MOD_DATE DATE
STG_CREATE_DT DATE
STG_ETL_PROCESS_DT DATE
STG_ETL_PROCESS_IND VARCHAR2(2)


Both Source & Target are Oracle Data.,
Please let me know if you Need any other Informations.
TIA
Super User
Posts: 5,428

Re: How can i Do the CDC in SAS DI 3.4?

Posted in reply to deleted_user
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).

Hope this helps,

Linus
Data never sleeps
N/A
Posts: 0

Re: How can i Do the CDC in SAS DI 3.4?

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

I am sorry I am new to SAS .

Thanks
SB
Super User
Posts: 5,428

Re: How can i Do the CDC in SAS DI 3.4?

Posted in reply to deleted_user
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.

/Linus
Data never sleeps
N/A
Posts: 0

Re: How can i Do the CDC in SAS DI 3.4?

In Our Shop we do not have any SAS programmer, I am the One suppose to get training also. In the mean time if you just show some light that will be great help.

All i want to know is how much Programming should i know for using SAS DI ?

TIA-SB
Super User
Posts: 5,428

Re: How can i Do the CDC in SAS DI 3.4?

Posted in reply to deleted_user
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.

/Linus
Data never sleeps
N/A
Posts: 0

Re: How can i Do the CDC in SAS DI 3.4?

Thank You So Much. SB
Ask a Question
Discussion stats
  • 8 replies
  • 153 views
  • 0 likes
  • 2 in conversation