cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
rajagopal_sampath
‎09-01-2015
  • 2 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Transformation in DataSurveyor for SAP

by Calcite | Level 5 in SAS Data Management
‎05-13-2015 05:29 AM
‎05-13-2015 05:29 AM
Thanks Linus, We have been using Informatica Tool to do ETL operations and perform staging on an Oracle db before loading the ERP data onto the data sets of SAS. Could this staging, done in Oracle database (for transformation purposes only), be avoided? I am asking this since all the operations in SAS are performed only after placing the data in SAS Data Sets. I assume that Data Surveyors for SAP would help eliminate the staging process. Kindly, correct me if I am wrong in my assumptions Linus Thanks, Raj ... View more

Transformation in DataSurveyor for SAP

by Calcite | Level 5 in SAS Data Management
‎05-07-2015 05:47 AM
‎05-07-2015 05:47 AM
Dear All, I am very new to this.. So kindly bear with me if I am wrong in this.. We are using SAP HANA. There are details about the manufacturing plants in it. Some of the plants don't exist now. Say, there were different plants initially A,B,C,D and E. Now, the plant E is shut down as all the work done in plant E is being done by plant D itself. The data in the ERP about transactions at plant E(old transactions) are now considered to be that of plant D's transaction in order to forecast the demand. If my understanding is right, I hope that the data is Extracted and Loaded in the SAS servers. So, is there a way to take care of the manipulations in the SAS side such that they don't modify the previous data in the ERP? Thanks, Raj ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:12 AM
Quick links