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

Mannamal-Oracle

Are the flat files on Hadoop? If not, this is not the right forum for this question. This forum is focused on Oracle Big Data Connectors that access and load data from Hadoop/HDFS into Oracle Database.