Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

how can u extract,transform and loading?

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


Please Help Members By Posting Answers For Below Questions

what is sas metadata repository? : Sas-bi

1118


How do dates work in SAS data?

1176


Explain proc sort?

1111


How do you specify the number of iterations and specific condition within a single do loop?

1103


What do you understand by the term Normal Distribution?

990


sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately

3588


If money were no object, what would you like to do?

3204


explain the concepts and capabilities of business object? : Sas-bi

962


if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming

1064


What is the different between functions and PROCs that calculate the same simple descriptive statistics?

1792


For clinical entire study how many tables will create approx?

1970


what is the purpose of _error_? : Sas programming

1136


Did you used proc test? when?

2040


How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?

1538


For what purpose would you use the RETAIN statement?

1524