Hi Guru's,

Although this is an Oracle related issue , i want to post this here,
because i know informix , not oracle , and since i am a newbie with
oracle , i cant make any comment about it. I am sorry for this but i
know in this group there exist Gurus who know both Oracle and Informix
very well . (Also , I think Oracle newsgroup is a little bit silence
place. )

What is the best way to load data to datawarehouse from the source
system if i use oracle ?

Simply ,

1 . select data from source system to fılesystem
2 . load data from file system to the warehouse database


Is there any binary unload-load option ? (Like informix - Hpl)

The oracle guys who i work with together says that they will use sql
level unload load instead of binary data unload load.Isnt it faster to
load data by using binary mechanism instead of sql approach?



How can i guarantee all this operations ? (If one fails - do that load
again )


Thank you very much for all replies.
Kind Regards,
hope

utkanbir wrote:

> Hi Guru's,
>
> Although this is an Oracle related issue , i want to post this here,
> because i know informix , not oracle , and since i am a newbie with
> oracle , i cant make any comment about it. I am sorry for this but i
> know in this group there exist Gurus who know both Oracle and Informix
> very well . (Also , I think Oracle newsgroup is a little bit silence
> place. )
>
> What is the best way to load data to datawarehouse from the source
> system if i use oracle ?

Load it into IDS and the use a gateway. :-)