GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  ETL
Go To First  |  Previous Question  |  Next Question 
 ETL  |  Question 34 of 64    Print  
I'am new to SAS, can anybody explain the process of extracting data from source systems,storing in ODS and how data modelling is done.

Reg
Ram

  
Total Answers and Comments: 3 Last Update: July 28, 2006     Asked by: ram_sas 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
July 18, 2006 05:59:27   #1  
Parasar        

RE: I'am new to SAS, can anybody explain the process o...

There are various ways of Extracting Data from Source Systems.For example , You can use a DATA step, an Import Process .It depends with your input data styles. What kind of File/database it is residing in. Storing ur data in an ODS can be done thru an ODS stmt/export stmt/FILE stmt, again which depends on the file & data format ,You want your output to be in.


 
Is this answer useful? Yes | No
July 18, 2006 12:52:16   #2  
Ram        

RE: I'am new to SAS, can anybody explain the process o...

In SAS what is Information Delivery Portal and Information Map Studio

Regards,

Ram


 
Is this answer useful? Yes | No
July 28, 2006 00:20:37   #3  
Monark        

RE: I'am new to SAS, can anybody explain the process o...

IDP is the portal for display of reports, stored process, information maps and a whole bunch of thing ideally required for a dashboard reporting.

IMS, is the gui to help u convert ur technical data and map it to business data (change names, add filters, add new columns etc)


 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape