One physical file as lookup file and also output of job?????

akash_nitj · Post by **akash_nitj** » Tue Feb 01, 2005 12:20 am

Hello Guys
Is it possible in datastage wherein i have a one physical file ( say dataset) which is used as lookup file in a job and in the same job we are doing some write operation in same dataset. Will there be any data quality issues in this front ?

TIA
akash

ArndW · Post by **ArndW** » Tue Feb 01, 2005 2:52 am

Since datasets are not true database files but a structure with sequential files you cannot really do this; if the files are opened for "read" by one process then another cannot get "write" access concurrently.

T42 · Post by **T42** » Tue Feb 01, 2005 1:58 pm

Correct.

You could just save it as a separate dataset file.

Also please note: Dataset does not compromise only one file. It's one header file, and a set of data files, with locations usually defined in the configuration file (it's possible to use other configurations for specific datasets.)