cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
VishantBhat
‎05-19-2021
  • 4 Posts
  • 1 Likes Given
  • 1 Solutions
  • 1 Likes Received
About
I am a SAS Consultant and a former SAS R&D India employee with over 9 Years of IT Experience in implementing & design of End-to-End Data warehousing (DWH) , ETL and BI solutions across Retail, Insurance, Health and Life Science domains.I have worked extensively IT Consulting and Services for Data warehouse and Business Intelligence solutions implementation projects. * SAS Consulting for Data warehousing Projects * Hadoop readiness and implementation * SAS Business Intelligence

Re: CDC on Source Table without Timestamp

by Fluorite | Level 6 in SAS Data Management
‎08-04-2016 08:58 PM
1 Like
‎08-04-2016 08:58 PM
1 Like
Added the SAS DI Studio transform code as Solution which was my SAS Global forum 2016 Presentation.   Regards, Vishant ... View more

Re: Did You Know: Creating New Surrogate Key Values from Table Loader

by Fluorite | Level 6 in SAS Data Management
‎08-04-2015 09:49 PM
‎08-04-2015 09:49 PM
Hi Tim, Can you pass the code you have for generating this? I am not able to open the attachment and I think this would be very helpful for me. ... View more

Re: CDC on Source Table without Timestamp

by Fluorite | Level 6 in SAS Data Management
‎07-21-2015 07:02 PM
‎07-21-2015 07:02 PM
Hi Linus, Don't we all wish for an ETL tool which can do magic between the Source and Target and give us the required solution I just wanted to explore possibilities on CDC, but I guess there are none for my current requirements. Thanks for your answer though. I might just go with a PROC COMPARE solution between the Source and current Staging datasets to do a CDC. Or I will wait if someone else has any answer to this. Regards, Vishant ... View more

CDC on Source Table without Timestamp

by Fluorite | Level 6 in SAS Data Management
‎07-16-2015 09:57 PM
‎07-16-2015 09:57 PM
Hi All, Currently in our DWH we perform a complete extract of all data from the source tables in Staging and perform a SCD on it on a daily basis (I know this is what sucks). But I now want to extract just the changed records from the source table instead of extracting the entire data from the source and performing a complete refresh and re-build the whole DWH on a daily basis. My problem is that I don't have any TIMESTAMP on the source tables (mostly oracle tables) which give me any Idea of the change dates. Can I perform a CDC on such a source which does not have a TIMESTAMP column on any of the source tables? I have never used a CDC transform before but was looking at DI studio General CDC, does this transform help in my case? Any help on this would be helpful and appreciated. Regards, Vishant PS: I am using SAS DI Studio v 4.7 ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎05-19-2021 05:52 AM
Likes given to
Likes from
View All
Quick links