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?

Answers were Sorted based on User's Feedback



how can u extract,transform and loading?..

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

how can u extract,transform and loading?..

Answer / arun

Extraction, transformation and loading can be done using SAS/ETL

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SAS Interview Questions

how to display duplicated observations in a data using base sas.

13 Answers   HCL, TCS,


%STPbegin;%STPEND; ERROR: No logical assign for filename _WEBOUT. WARNING: No body file. HTML output will not be created. unable to fix it.plz help

2 Answers  


how do you want missing values handled? : Sas programming

0 Answers  


Explain proc sort?

0 Answers  


If you set a label in the data step and call a proc freq on the data, how do you display the data without the labels and just the variables.

1 Answers  


how do you test for missing values? : Sas programming

0 Answers  


Name few SAS functions?

0 Answers  


explain the key concept of sas? : Sas-administrator

0 Answers  


What does P-value signify about the statistical data?

0 Answers  


which domain is better in sas? clinical trails or banking

3 Answers  


How do you put an elephant in the refrigerator?

6 Answers   Oracle,


wat is sas? is a package or programming language?

4 Answers  


Categories