Home » Developer & Programmer » Data Integration » Handling bad recordsin the bad file?
Handling bad recordsin the bad file? [message #195430] Thu, 28 September 2006 10:02
gowthamsen
Messages: 14
Registered: August 2006
Junior Member
Hi,

>> I am using external tables for loading data from text files. I am doing it well.

I came across a case, where some records are not good, those records are diverted to bad file.

In that case, we are losing the valuable data. We can do some validation and we can use it.

Could anyone please suggest me the way we could perform this.

>> And I have one more doubt. Using OWB we can create single external table for multiple files.

I would like to differentiate the records of each file, by adding filename as one extra field.

Can we do this using owb?

Any suggestions are welcome.

Thanks and regards
Gowtham Sen.
Previous Topic: Peoplesoft Connectors and Ebiz Connectors
Next Topic: Running shellscript as external process in owb?
Goto Forum:
  


Current Time: Thu Mar 28 05:48:51 CDT 2024