how can u extract,transform and loading?
- 2 Answers
- 5657 Views
- CitiGroup, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / arun
Extraction, transformation and loading can be done using SAS/ETL
| Is This Answer Correct ? | 0 Yes | 0 No |
how to read raw data in sas. Do it manually and throw the programming.
Code the MEANS to produce output to be used later.
what is data access? : Sas-di
How we can create SAS USER DEFINED CODE?
Explain how you can debug and test your SAS program?
What is the difference between order and group variable in proc report?
If money were no object, what would you like to do?
What is the difference between Proc tabulate and Proc print
When looking for data contained in a character string of 150 bytes, which function is the best to locate that data: scan, index, or indexc?
What do you feel about hardcoding?
What is PDV?
What is the basic syntax style in SAS?
Teradata 
