DSXchange

Is there any option other than renamiming the Production files....

i am overwriting the file, but while loading the last run records are loaded...
Is ther any problem whiile overwriting the file without any records or do i have to change any properties in dataset ??

Thanks,

But i should not run the yesterdays files again and again..?

Thanks,

But i should not run the yesterdays files again and again..?

Thanks,

i have the date in the records itself, So there is no need to consider the date part...

I searched for any topics regarding FILE PATTERN,
but i could find in dsxchange..
Can you please shre me the idea of using it or the thread that has the detail about it..

Thanks,
Raj

I searched for any topics regarding FILE PATTERN,
but i could find in dsxchange..
Can you please shre me the idea of using it or the thread that has the detail about it..

Thanks,
Raj

I searched for any topics regarding FILE PATTERN,
but i could find in dsxchange..
Can you please shre me the idea of using it or the thread that has the detail about it..

Thanks,
Raj

Actually, i am tring an option of skipping the job, But if there is any other option, i can try that too...
Hence i tried to clarify my requirement...

Thanks,

My requirement is : Not to load the last run records to the database if the current run produses no records.
Can this be achievable by any other way(By not skipping the job)

Thanks.

We are running in daily cycle, So it will not be a null dataset.
The problem in my case is :The records of the last run was loading again in the dataset creating duplicate records.

Thanks

Hi all, I have to read a txt file and load it to the database.This is daily cycle. The file name is in the format say,SAMPLE_20091020.txt,SAMPLE_20091021.txt .. I cant change the file name manually ... How can i handle this situation of handling the file and getting the date from it. Thanks in advan...

Hi all,
I am using the target dataset of a job1 as an input of job2.I have skip the job2 if no records was passed to the target dataset in the job1
How can i achieve this,Can anyone suggest me a solution..

Thanks in advance

While loaading a dataset with 26 records to the TARGET Database Oracle, i could able to load only seven records with an error message: Oracle_Enterprise_135,3: The system(sqlldr scretl/scretl@tpcs CONTROL=ora.2928834.310994.3.ctl LOG=ora.2928834.310994.3.log BAD=ora.2928834.310994.3.log.bad SILENT=h...

Actually i haven't created any config files and ini files..
Can you tell me how to enable this...
Thanks,