Interested to Buy Any Domain ? << Click Here >> for more details...
how can u extract,transform and loading?
- 2 Answers
- 6832 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
What is the basic structure of the SAS base program?
do you prefer proc report or proc tabulate? Why? : Sas programming
is data integration and etl programming is same? : Sas-di
Describe the ways in which you can create macro variables?
what is the difference between unique key and primary key? : Sas-di
if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation
How long can a macro variable be? A token? : sas-macro
sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately
what is sas database server? : Sas-di
Which command is used to perform sorting in sas program?
describe the interaction table in sas di? : Sas-di
What are the differences between proc means and proc summary?
Do you know the features of sas?
which date function advances a date, time or datetime value by a given interval? : Sas programming
What is substr function?
