Data Source is empty after job finished successfully

[nraj]

Hi,

I'm loading a Seqfile data into a oracle target table,job finished without any warning or error but data is not loaded into my staging table.


But in performance statisticks data flow is accurate.

Pls advice me how to go about it.



Thanks
Raj

[ArndW]

What stage are you using to load Oracle? Do you have a reject link defined?

[chulett]

If you are sure there are no warnings when you check the job's log from the Director and the monitor shows the correct number of rows going 'in' to the target stage, check a couple of things:

Double-check the table name you are writing to. Are you specifying a schema/owner in the stage? Also double-check the update action - if it is set to something like 'Update existing rows' rather than Insert you'll see the behaviour you have noted - all go in and none stick.