Interested to Buy Any Domain ? << Click Here >> for more details...
how can u extract,transform and loading?
- 2 Answers
- 6638 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 the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming
How do you put an elephant in the refrigerator?
how can u convert this 25-jul-2010 from numeric to charcter?
How do you write a test plan?
What is the basic structure of a sas program?
What are the Aggregate functions in SQL ?
What does the RUN statement do?
What is the function of output statement in a SAS Program?
Describe what are the different levels of administrative users in sas? : sas-grid-administration
What is the difference between where and if statement?
what is hash files in sas and why we are using this one in sas?
what are different analysis datasets you created and what are the new variables created
Teradata 
