how can u extract,transform and loading?
- 2 Answers
- 6192 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
how to change the execute of macro
What is a macro routine?
What is PROC in SAS?
Which function is used to count the number of intervals between two sas dates?
What would be the value of month at the end of data step execution and how many observations would be there?
What are SAS/ACCESS and SAS/CONNECT?
What is the maximum length of the macro variable?
How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?
What do the sas log messages “numeric values have been converted to character” mean? What are the implications?
What is the maximum and minimum length of macro variable
what is the use of proc contents and proc print in sas? : Sas-administrator
What is the function of Stop statement in a SAS Program?
AE datasets names? how many types?
What is by-group processing?
I need level 2 to 5 sas using companies in india
