[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 879
  • Last Modified:

Teradata/mainframe data export

I have a client who is going to be pushing data to us daily. I have gotten a couple of test files as .txt. I need to import the data to a mysql db. The problem ther e seams to be no blanket formatting to the files. Some of the data looks to be formated tab delimitid or csv but we can't find anything that works for the entire file. Can anyone give us some pointers as to how to deal with this data?
0
cebrooks03
Asked:
cebrooks03
  • 2
1 Solution
 
Gustav BrockCIOCommented:
Not much to work with here ...

Note that when inserting records reading the records off a text file using

  LOAD DATA INFILE
    '../data/test.txt'
  INTO TABLE
    tempload

into an empty non-indexed table runs at extremely high speed.

However, the file is read "as is" so the formatting much be 100% verified otherwise - and that means from the source.

Ask the client to provide full documentation of the format of the file.

/gustav
0
 
cebrooks03Author Commented:
I apologize for the delay.
0
 
Gustav BrockCIOCommented:
No problem.

/gustav
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now