2 Replies Latest reply: May 8, 2012 1:14 AM by RaviR RSS

    OWB and .CSV file

    RaviR
      Hi Gurus,

      I need to check the scope of the OWB tool.

      1. Would it be preferable to have the flatfile use the same name everytime, or would it be better to have the date appended.
      2. Can OWB (after importing data succesfully), archive this file into another directory and store it renamed with the timestamp appended to the filename.
      3. In case of an error, can the flatfile be moved to another directory instead of the regular archive directory.
      4. Is there any preference in the CSV structure that would be helpful, coz we can define a structure suitable for us.
      5. The above tasks 1-3 can be handled by EDI tools like GIS.Does OWB can do it, using any of the new features.

      Regards,
      Ravi Remje
        • 1. Re: OWB and .CSV file
          Igor.M
          1. Would it be preferable to have the flatfile use the same name everytime, or would it be better to have the date appended.
          http://jiri.wordpress.com/2010/01/19/no-more-unix-scripts-in-11-2/
          http://download.oracle.com/otndocs/products/database/enterprise_edition/utilities/pdf/xtables_preproc11g_1009.pdf
          2. Can OWB (after importing data succesfully), archive this file into another directory and store it renamed with the timestamp appended to the filename.
          3. In case of an error, can the flatfile be moved to another directory instead of the regular archive directory.
          Use "Post-Mapping process" or "Process Flows"
          http://docs.oracle.com/cd/B31080_01/doc/owb.102/b28223/ref_processflows.htm
          4. Is there any preference in the CSV structure that would be helpful, coz we can define a structure suitable for us.
          http://docs.oracle.com/cd/E11882_01/server.112/e16536/et_concepts.htm
          • 2. Re: OWB and .CSV file
            RaviR
            Thanks a ton Igor.