Can i move an PDF object into my oracle target

[raj_prodigy]

Hi,
Can anyone please tell how can i use an PDF object itself in to my Oracle target. DO we have a stage to handle this....!

PLease help me asap....urgent requirement....!

Thanks
Raja

[chulett]

I'm sorry that your first post here is for something 'asap' and 'urgent' as there really isn't any such thing here. If you urgently need help you should contact your official support provider, that's why your company pays them the big bucks. Here, we're all just volunteers who help when we can.

No, there's no specific stage for pdf files as they are not your typical ETL targets. First question should pretty much always be - how would you do this without DataStage? Answer that for us and then we can help determine if/how that can be accomplished via the tool or if you are better off taking another approach. Just because DataStage is a mighty fine hammer, that doesn't turn every problem into a nail.

I'd suggest a chat with your friendly neighborhood DBA man if you're not sure of the answer, which will primarily depend on exactly how you plan on storing it in Oracle.

[ray.wurlod]

Stick it in a directory (which Oracle can access as an "external table" - Larry-speak for a directory).

[raj_prodigy]

I shall try out the options u mentioned....!
Thanks for the time...!

[chulett]

Flat files can be treated as 'external tables' but I don't see how pdf files could. And you'd need to create the Directory object first in Oracle.

[ray.wurlod]

One BLOB column. One row.

[chulett]

Yah, umm.. well, except like that.