how can u extract,transform and loading?
Answer Posted / basha
DATA IS EXTRACTED FROM DATABASE(ANY RELATIONAL DATABASE)
AND TRANSFORM THE DATA IN TO SAS BY USING GLOBAL VARIABLES
IN SAS/ETL I.E DBMS CONNECTIONS,LIBRARIES(SOURCE) AND ODD
(OPRATIONAL DATA DEFINITION GROUP) AND PERFORMING REQUIRED
MATHEMATICAL OPERATIONS IN BETWEEN SOURCE TABLES TO THE
FACT TABLE TRANSFORM THE DATA AGAIN LOADING THE DATA INTO
DATABASE BY USING TARGET LIBRARIES
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what is sas metadata repository? : Sas-bi
How do dates work in SAS data?
Explain proc sort?
How do you specify the number of iterations and specific condition within a single do loop?
What do you understand by the term Normal Distribution?
sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately
If money were no object, what would you like to do?
explain the concepts and capabilities of business object? : Sas-bi
if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming
What is the different between functions and PROCs that calculate the same simple descriptive statistics?
For clinical entire study how many tables will create approx?
what is the purpose of _error_? : Sas programming
Did you used proc test? when?
How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?
For what purpose would you use the RETAIN statement?