how can u extract,transform and loading?
- 2 Answers
- 6136 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 |
Describe what are the different levels of administrative users in sas? : sas-grid-administration
In SAS explain which statement does not perform automatic conversions in comparisons?
i have a dataset with 25 obs; 10th obs has like ramu,anji,ramu,azad,ramu like this. i want to know how many times the word repeats in that obs?
how to know the attributes of first five datasets in a library
Which command is used to save logs in the external file?
How would you include common or reuse to be processed along with your statements?
What was the last computer book you purchased? Why?
what is the prob plot in clinical domain
What is the difference between class statement and by statement in proc means?
what are the differences between proc report and proc tabulate?
What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?
How do you control the number of observations and/or variables read or written? Approximately what date is represented by the SAS date value of 730?
Teradata 
