| 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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
