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

diff between nodup rec and ondup key???

3 Answers   AON, Sciformix,

How do you add a number to a macro variable? : sas-macro

0 Answers  

i have a dataset with var1,var2,var3; i want to upload the titles for the variables . How can we?

1 Answers   GSK,

what is TAB delimiter? explain about it? what will you do to get TAB delimiter?

3 Answers   Cap Gemini,

Of all your work, where have you been the most successful?

0 Answers   Oracle, Six Sigma,

How we can call macros with in data step? : sas-macro

0 Answers  

how to read character value without using substr function in sas ?

3 Answers  

how many display types available in sas bi dashboard? : Sas-bi

0 Answers  

what is the main difference between rename and label? (don't say that they both perform the same function).

11 Answers   Parexel,

what are the types of interactive display types? : Sas-bi

0 Answers  

what are the categories that sas informats are used to the place the data? : Sas-administrator

0 Answers  

How would you code a merge that will keep only the observations that have matches from both sets?

5 Answers  

For more SAS Interview Questions Click Here
Categories