how can u extract,transform and loading?
- 2 Answers
- 5724 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 |
What is PROC in SAS?
what is hierarchy flattening? : Sas-di
Does SAS ‘Translate’ (compile) or does it ‘Interpret’? Explain.
What are types of transport files?
2 Answers PRA Health Sciences, Quintiles,
How sas treats the dsd delimiters?
What is the purpose of _error_?
what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming
What are the analysis datasets created, and what are the new variables created in CLINICAL SAS
1 Answers Accenture, Sciformix,
What is the difference between Regression and Logistic Regression? Can u explain the Assumptions/Conditions?
List down the reasons for choosing sas over other data analytics tools.
What is the difference between %local and %global?
What is difference between Global n Local Macro Variables..?
Teradata 
