Interested to Buy Any Domain ? << Click Here >> for more details...
how can u extract,transform and loading?
- 2 Answers
- 6734 Views
- CitiGroup, I also Faced
- E-Mail Answers
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 |
Name statements that are recognized at compile time only?
In PROC PRINT, can you print only variables that begin with the letter “A”?
what techniques and/or procs do you use for tables? : Sas programming
what is enterprise guide? What is the use of it? : Sas programming
How would you determine the number of missing or nonmissing values in computations?
I have 50 variables in one data set, In reports i want to generate every 10 variables in one page how we will write code in proc report.
how to read the variables in sas? : Sas-administrator
Which is the best place to learn SAS clinicals and Oracle clinical in hyderabad?
what is the purpose of _error_? : Sas programming
How the date 04oct1994 is stored in SAS,not only give the answer explain in brief?
Below is the table. Required to be output should be the highest number of each student_id. Example. Student_id Subject Marks 1 Hindi 86 2 Hindi 70 3 English 80 . Calculate sum and average marks for each group of student_id Example. Student_id Subject Marks Total Marks Average 1 English 40 181 60.33333 2 English 67 196 65.33333 3 English 80 160 53.33333 PLEASE PROVIDE THE CODE OF ABOVE PROBLEMS
What are the data types in sas?
Teradata 
