Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-05-12 : 07:16:47
|
| gaurav writes "Data Extraction:1.Does your software allow for the data extraction from the data sources like IMS,VSAM,DB@ etc. If yes, are there any unusual (custom) set up required to link to the legacy system(s) or is this an inherent part of your solution?2.Explain your software’s ability to profile and analyze the data in the legacy system(s).3.To what format will the data be extracted to? ASCII, RDBMS, etc. Data Cleaning:1.Where is the extracted data held while the cleaning efforts are taking place? Your software, an RDBMS, other?The City wishes to move to a single view of our customers within the ERP system. Explain your ability to take data regarding customers (names and addresses) and parse single line fields, clean/transform inconsistent data and match duplicate customer records.2.Explain your ability to consolidate cleaned data from multiple legacy systems for insertion as a single record into the destination system (i.e. Customers who are duplicated in 5 systems).3.Explain any ability to identify and link members of the same household. 4.How many pre-built routines does your system have for cleaning common data problems (names in one field, addresses in one field)?5.Explain your ability to match “fuzzy” data. For example “Pothole repair” and “Repair of pothole”.Data Loading:1.What type of effort is involved in loading data into the ERP system once it has been cleaned?2.Do you have any pre-built tools for insertion of data into Peoplesoft or SAP?General1.Is the extraction, cleaning and loading process repeatable? If yes, once the initial routines are established can this process be run again without human intervention to clean data?2.Do you have version control so as to keep technical staff from working on the same activities or changing finished processes?3.Are there limitations on the amount of data that can be processed in a given period? If yes, please elaborate.4.What are your precautions for keeping the system from crashing with process intensive tasks?5.Please describe your implementation process. Does the product require your staff to install and configure or is this a task the City can do?" |
|
|
|
|
|
|
|
Sql Serv 2000 -DTS