Data File

pavan_test · Post by **pavan_test** » Wed Jan 20, 2010 3:16 pm

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

chulett · Post by **chulett** » Wed Jan 20, 2010 3:40 pm

It doesn't generate a .dat file like it does for the .ctl/.log/.bad files, it streams the data through a named pipe instead.

pavan_test · Post by **pavan_test** » Wed Jan 20, 2010 3:59 pm

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

chulett · Post by **chulett** » Wed Jan 20, 2010 4:09 pm

It's a named pipe so there's nothing to find, data wise. You get that, yes? And from what I recall it deletes it afterwards which is why you don't see it in the same location as the other files.

pavan_test · Post by **pavan_test** » Wed Jan 20, 2010 4:19 pm

i understand that etl will delete this file and it does not contain any data.

what is named pipe.

Thanks
Mark

ray.wurlod · Post by **ray.wurlod** » Wed Jan 20, 2010 4:22 pm

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.

chulett · Post by **chulett** » Wed Jan 20, 2010 6:10 pm

Like so.

http://en.wikipedia.org/wiki/Named_pipe