how can u extract,transform and loading?
Answers were Sorted based on User's Feedback
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 |
Answer / arun
Extraction, transformation and loading can be done using SAS/ETL
Is This Answer Correct ? | 0 Yes | 0 No |
What is your favorite all time computer book? Why?
What is the difference between verification and validation?
Tell me about % include and % eval? : sas-macro
what is option year cuttoff in sas
How would you delete duplicate observations?
. Which date advances a date, time or date/time value by a given interval?
How would you include common or reuse code to be processed along with your statements?
How we can call macros with in data step? : sas-macro
Name any two sas spawners? : sas-grid-administration
What are the five ways to do a table lookup in sas? : sas-grid-administration
In the following DATA step, what is needed for ‘fraction’ to print to the log? data _null_; x=1/3; if x=.3333 then put ‘fraction’; run;
For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration