1 Reply Latest reply: Feb 11, 2013 12:04 PM by Mannamal-Oracle RSS

    flat to DB flow : No error encountered but data is not getting loaded

    989691
      Hi All,

      i am designing a simple flat to db interface.
      When i run the interface i get no errors. but the data is not getting pulled from the flat file.

      For creating the flat file connection in topology, i have used
      JDBC Driver: com.sunopsis.jdbc.driver.file.FileDriver
      JDBC URL: jdbc:snps:dbfile

      I have tested the connection and it shows success.

      But when i check in the operator, in the step where it loads data from file to temporary table, it shows 0 rows inserted.

      Please can anyone help me with this issue.
      Let me know if you require any further details.

      Thanks & Regards,
      Prasad