Interested to Buy Any Domain ? << Click Here >> for more details...
how can u extract,transform and loading?
- 2 Answers
- 6711 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 read the variables in sas? : Sas-administrator
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
Give e an example of..
What do the PUT and INPUT functions do?
How you can read the variables that you need?
How will you use the WHO Drug Dictionary for Reporting Clinical Trials?
What is the basic syntax style in SAS?
what are the scrubbing procedures in sas? : Sas programming
What Proc glm does?
Describe what are the different levels of administrative users in sas? : sas-grid-administration
What was the last computer book you purchased? Why?
What would be the value of month at the end of data step execution and how many observations would be there?
Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?
What is the difference between %put and symbolgen? : sas-macro
Explain data step in SAS
