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

what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming

0 Answers  


How to get top scorer student from a class-table having different sections A,B, C & D? Each section having same number of students.

2 Answers  


how do you want missing values handled? : Sas programming

0 Answers  


Does anybody have SAS Training manual or documentation or can you refer me any book to have better understanding on SAS. I am fresher to SAS tool. (Ready to pay)

4 Answers  


Explain how merging helps to combine data sets.

0 Answers  


what are the advantages of using SAS in clinical data mangement? why should not we use other software products in managing clinical data?

2 Answers   Wockhardt,


what is study design in while working with SAS? what are screening variables in SAS?

0 Answers   MSCR,


Which are the statements whose placement in the data step is critical?

0 Answers  


One way of creating a new variable in Macros is by % Let....What is the other way..?

5 Answers   TCS,


What is proc sort?

0 Answers  


i have a dataset with 100000 records. i want 100 records from that dataset and create a dataset.we need to pick the observations random order like 100obs,500obs,1020obs,1890obs,2565obs like that i need 100 obs in random order? how can we create this one?

5 Answers   L&T,


Hi... this is chandu, did MSc Microbiology, trying to get job in SAS tool, PLZ Tell me whether IT industries will give consider my education to gain a job....?

2 Answers  


Categories