I have a etl job which loads data into a oracle DB using sql loader (Load option within ORAcle EE stage). I am trying to find the sql loader data file generated by etl. can anyone suggest me where do I find this data file.
Thanks
Mark
Data File
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 263
- Joined: Fri Sep 23, 2005 6:49 am
Data File
Inside the generated control file ora.xxx.xxx.o.ctl file i found a data infile as ora.xxx.xxx.fifo.0 "FIX xxxx"
where do I find this fifo file.
Thanks
Mark
where do I find this fifo file.
Thanks
Mark
-
- Premium Member
- Posts: 263
- Joined: Fri Sep 23, 2005 6:49 am
Data File
i understand that etl will delete this file and it does not contain any data.
what is named pipe.
Thanks
Mark
what is named pipe.
Thanks
Mark
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Why don't you research this, perhaps by a Google search?
It is a technique available in all operating systems for transferring data between a writer process and a reader process.
It is a technique available in all operating systems for transferring data between a writer process and a reader process.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.