Interested to Buy Any Domain ? << Click Here >> for more details...
how can u extract,transform and loading?
- 2 Answers
- 6633 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
Are you involved in writing the inferential analysis plan? Tables specfications?
Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?
What is substr function?
how many types of prompts are there? : Sas-bi
why is sas considered self-documenting? : Sas programming
If a variable contains only numbers, can it be a character data type?
What is a macro routine?
What are the limitations for memory allocation for SAS variables
What is the role of sas grid administrator? : sas-grid-administration
what is null hypothesis? why do you consider that?
do you need to know if there are any missing values? : Sas programming
which features do you use to check the data validations and errors? : Sas-administrator
why is sas data integration studio important? : Sas-di
If you were told to create many records from one record, show how you would do this using array and with proc transpose?
what other sas products have you used and consider yourself proficient in using? : Sas programming
