DSXchange

Hi,

I'm loading a Seqfile data into a oracle target table,job finished without any warning or error but data is not loaded into my staging table.


But in performance statisticks data flow is accurate.

Pls advice me how to go about it.



Thanks
Raj

Hi,

I have created a simple job which loads data from Teadata to Dataset file,
job got aborted with fatal error,

Parallel job reports failure (code 139)

Plz advice me how to go about it,,,,

Thanks

Hi

please let us know any commond or search mode to find job name and table name in group of jobs in Datastage



Thanks
Raj

Hi,

could you please let us know how we can remove duplicates in Datastage jobs and commond in unix which does this job.


Thanks
Nraj

Hi ArndW

Yeah i'm Expecting DataStage generated keys using the KeyMgtGetNextValue only.

Plz let us know the Sql which does the reset of SRkey.

Hi

Is there any DS-commond line query to reset Surrogate Key ?

Thanks

Yeah Arnd u r right, i will come out with some specific issues.

Thanks

Plz let us know some best practice steps to improve performance.
In Datastage jobs.

Thanks

Thanks For Suggestion - Arnd

Thanks AnndW

We have not found Break point option to Debug the error in Parallel Extender Datastage Designer -v-7.1
Plz let us know it is specific only to Server jobs.


Thanks

Hi

Plz tell me more about MQ and its importence.

Why we need this MQ series what is the benifits of this ?

Thanks

What is the Significance of job controller.

where we will find jobcontrol.H file.

How importent is this in the job designs.

a surrogate key is 4 byte int bu which we can track 2 billion records,

if records more than 2 billion what is the solution