BASE SAS
|
SAS DATA INTEGRATION
STUDIO
|
Source data Adaptors, SAS can access just about any
known data source through their native access engines and open standards
approaches.
|
The same functionality is surfaced in SAS Data
Integration Studio through metadata.
|
Base SAS has conditional logic support
(if-then-else), so you can’t act on whatever observations or columns you
wish.
|
Data Integration Studio Has a built in extract
transformation
|
We have a tremendous amount of functionality at our
disposal for doing the matching and retention of good values.
|
We have standard transformations as well as ability
to create customer transformations that can be drooped onto the process
editor.
|
We define surrogate key and simply increment the
values each time a new record is added.
|
There is a surrogate key generator that will handle
the creation of a new key for you when you load the table.
|
To implement DW BI we are using open source and Propritory tools like SAS, Cognos, Informatica,Pentaho, Japser, Talend, BIRT and many. In this blog i am sharing all my experiences of pentaho , Japsper & Talend.
Thursday, 5 July 2012
Base SAS Vs SAS Data Integration Studio
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment