Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: datas loading in one transaction?

  1. #1
    Join Date
    Aug 2007
    Posts
    4

    Default datas loading in one transaction?

    Hello All,

    I have spent many time on this issue with no solution.

    The context is this one:

    I load mysql tables from text files.
    I would like to know if there is a way to proceed a loading of one table from one file in a single transaction?

    Indeed, if loading for various reason has an error the records before the error keep stored in the database and of course records from error are not sored in the database.

    Thanks in advance for you help.
    Best Regards.
    boulanou

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    Not really unless you want to load files in one transformation and switch unique connection on... but then you will probably get concurrency problems.

    Stage your files and you can do it. Load all text files to 1 "temporary" table and load the real table starting from that 1 temporary table.

    Regards,
    Sven

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.