flat to DB flow : No error encountered but data is not getting loaded
989691Feb 7 2013 — edited Feb 11 2013Hi 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