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...

  1. Categories >> Software >> Data Warehouse >> SAS
  2. Suggest New Category

how can u extract,transform and loading?

Question Posted / akshara

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 are different analysis datasets you created and what are the new variables created

2 Answers   Sciformix,

Code a PROC SORT on a data set containing State, District and County as the primary variables, along with several numeric variables?

3 Answers  

i have a dataset with 25 obs; 10th obs has like ramu,anji,ramu,azad,ramu like this. i want to know how many times the word repeats in that obs?

3 Answers  

what is information maps?

0 Answers   CitiGroup,

Explain data_null_?

0 Answers  

If a variable contains only numbers, can it be a character data type?

0 Answers  

tell me about use of arrays in sas

1 Answers   CoreEL,

what is data governance? : Sas-di

0 Answers  

What is SAS Information Map Studio and its purpose ?

2 Answers   SAS, TCS,

What is the order of application for output data set options, input data set options and SAS statements?

0 Answers   Quintiles,

What is maximum storage capability of SAS?

0 Answers  

Hi All.I am looking for Good Institute who could Provide the online SAS BI+DI Training along with software.Primarily in Delhi/NCR or in Hyderabad Please help with name and contact number of concerned person!! Thanks in Advance! :)

1 Answers  

For more SAS Interview Questions Click Here
Categories