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

How can i Do the CDC in SAS DI 3.4?

deleted_user — Mon, 05 Jan 2009 16:42:05 GMT

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

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

LinusH — Wed, 07 Jan 2009 10:06:23 GMT

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

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

deleted_user — Wed, 07 Jan 2009 14:09:46 GMT

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

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

LinusH — Wed, 07 Jan 2009 14:24:48 GMT

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

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

deleted_user — Wed, 07 Jan 2009 14:41:49 GMT

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

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

LinusH — Wed, 07 Jan 2009 14:47:43 GMT

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

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

deleted_user — Wed, 07 Jan 2009 15:04:02 GMT

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

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

LinusH — Wed, 07 Jan 2009 15:14:57 GMT

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

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

deleted_user — Wed, 07 Jan 2009 15:33:44 GMT

Thank You So Much. SB