how can u extract,transform and loading?
- 2 Answers
- 5689 Views
- CitiGroup, I also Faced
- E-Mail Answers
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 do the sas log messages "numeric values have been converted to character" mean? : Sas programming
Explain bmdp procedure?
Define run-group processing?
what does the run statement do? : Sas programming
What are the statements that are executed only?
What are the table names in oracle database...?
what has been your most common programming mistake? : Sas programming
what is the use of proc sql? : Sas programming
what is the effect of the options statement errors=1? : Sas programming
What is SAS informats?
Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro
in the flow of data step processing, what is the first action in a typical data step? : Sas programming
What is the function of output statement in a SAS Program?
Explain the difference between nodup and nodupkey options?
AE datasets names? how many types?
