Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

I am new to sas, can anybody explain the process of extracting data from source systems,storing in ods and how data modelling is done?

Answer Posted / Nitin Azad

{"data extraction": "In SAS ETL, data is extracted from various sources like databases, flat files, or web services using procedures such as PROC SQL, PROC COPY, or custom-written macros.","ODS (Operational Data Store) storage": "The extracted data is then stored in an ODS (Operational Data Store), which is a high-performance data warehouse optimized for ETL operations. SAS provides several built-in ODS engines like ODS Table, ODS Log, and ODS Graphics.","data modeling": "Data modeling in SAS involves designing the structure of the data and the relationships between different entities. This is typically done using SAS Data Dictionary, which allows you to define tables, columns, relationships, and constraints. You can also use the Business Intelligence Platform (SAS BI) for more advanced data modeling features."

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

No New Questions to Answer in this Category !!    You can

Post New Questions

Answer Questions in Different Category