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?
- 1 Answers
- 30 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
When do you analyze the tables?
How to determine what records to extract?
What are materialized views & where do we use them? What is a materialized view log?
What are the various tools? - Name a few?
What are parameter files? Where do we use them?
What are materialized views & where do we use them? What is a materialized view?
What are snapshots? What are materialized views & where do we use them? What is a materialized view?
How do you analyze the tables
Where do we use connected and un connected lookups?
What is the purpose of a staging area?
What are active transformation / passive transformations?
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?
Oracle General 
