DSXchange

The Block size is set to 1.

I have changed the Oracle to Sequential file. SO my job is now Dataset ->> Surrogate Key Stage -->> Sequential file. I ran the Job twice. Surrogate key stage runs in the Sequential mode. I could see that the in the First run the SK is generated from 1 to 475 and in the Next run it generated from 477...

In the dataset it is just 475 records and 475 records got loaded to the database. The message is flagged against the surrogate key stage. Also there is one extra surrogate key is getting generated. i.e for the first load say key is generated from 1 to 475 and in the next run it is generating from 47...

My job looks as follow: Job 1 Dataset --> Surrogate Key Generator -> Oracle Input dataset has 475 Records. When I observed log there is something i could not understand. In the log it shows Output 0 produced 476 records although in dataset only 475 Records are there. can we do anything about this? T...

Hi,
I am calling SQL Server stored procedure from ODBC stage.
The Problem is even the stored procedure fails the Job complets finished OK.
Please tell me what i need to do to abort the Job when Stored procedure is not finished successfully.


Thanks,

Hi,
You have to create the configuration file for the multiple node.
You might need to check the partitioning in your jobs to get the proper output.

Thanks,

you can use KeyMgtGetNextValue function

Hi, Hope the followings will help to understand the problem better: 1. Suppose a job control "JbCntrl" to run the sequnce Job "JbSequence" 2. JbCntrl reads the Parameter files and Sets the Parameter for JbSequence. 3. JbSequence has many subsequnces and Job in it 4. JbSequence is...

Hi, I have a Job sequence which is Checkpoint enabled. I have a Job Control code to call the Job Sequence. The Job Control code reads the parameter file and sets the parameter to Job Sequence. The Problem i am facing is when i run the Job sequence from job control, the checkpoint does not work. But ...

Why dont you try to join the tables in the source stage itself before extraction?

Try to access data by DRS stage.

Are you getting just count of the record in the output Sequential file.
If yes then you can use wc -l < inputfilename > outputfilename to get the count.

It depends on the job architecture and the CPU load at the particular time when job is run.

Hi, I have a pipe delimited file with follwoing column: Countryname oldid newid newname I have the table with following column country id name datetimestamp I have to replace the old id with new id in the table. I am using following query in odbc update <table> set id=?, name=? where country=? and i...

Hi, I have source file in ISO8859-1. But the database is in UTF-8. When i load the file in the database then it is converted to ?. Hence when the data is unloaded from database again for some other process then we get wrong output. Anybody please suggest if this cane be controlled any way? Thanks,