Data Extaction and Cleansing as/400
Home > IT Answers > AS/400 > Data Extaction and Cleansing as/400
Dataextract
15 pts.
0
Q:
Data Extaction and Cleansing as/400
as/400 data, AS/400 Transfer, AS/400 Data File
What is the best way to extract and clean data from AS/400 dbase?  We are planning to replace legacy systems with an integrated package that may have a different dbase.  Is there a good product / service?

Software/Hardware used:
as/400
ASKED: Nov 13 2009  8:46 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
CharlieBrowne
6350 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Unless your file descriptions for both systems and the field names care exactly the same, a tool is not going to be found that can do this.
You need to define all your fields in the legacy system and the files they are comming from.
Then do the same with the target system.
Most likely you will have some fields that do not map and you to make a determineation for each one.
Last Answered: Nov 13 2009  9:39 PM GMT by CharlieBrowne   6350 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Dataextract   15 pts.  |   Nov 14 2009  5:16AM GMT

Can you please clarify for non-techie. I assume we are left with a multi-step process like:
1. writing SQL to pull data from DB2/400
2. create file for input into utility or excel etc for cleaning
3. update new dbase (from cleansed file) with import program that should exist with new application.

Thanks

 

CharlieBrowne   6350 pts.  |   Nov 14 2009  4:23PM GMT

Yes, that’s about it.
The hardest part is field mapping.
On your current system, you may have a data file with a data element called CODE. It may have a value of A, B, or C. You will need to know what to do with those codes. Are they still needed? Do you need to write values to different files depending on the code? If you have CODE = A, does that mean the you have to have values in other files?
The point here is you need to understand all the data elements on the current system and then be able to map them to data elements on the new system.

 
0