DSXchange

Hi Gurus, In my new reuirement, we need to add the extra local parameter value while running the sequence. Example: we have common job, in that job source query we have the logic as COLUMN='#LOCAL_PARAMETER#'.(LOCAL_PARAMETER is string type) while runtime we are passing #LOCAL_PARAMETER#="XXXX&...

hi Our requirement is first time we will get information from source we will insert all the data(for 1st time) from 2nd time onwards we need to identify the flags. whether the record is new record or existing record and if any record not coming from the source and existing in target we need to delet...

ray.wurlod wrote:Are you providing an invocation ID in DSAttachJob? ...

Yes, we are providing the invocation ID to the DSAttachJob.

Is your multi-instance job running another job 'before job'? If so, is that other job MI as well? :? ... Yes, In my sequence we are calling the MI job 12 times , but flow is sequential (i.e one MI with some invocation id after this job completion , next MI with different invocation id like this we ...

Hi Guru's, we have the Multiple instance job, That job getting aborted and giving fatal error as follows: JobAuditReport..BeforeJob (DSAttachJob): Job control error (-12) (DSOpenJob) Cannot get shared access to executable file for job XXXX. what may be the possible reason for this? Thanks in advance...

Hi, As a part one of the my requirement is, Currently we get getting data(source) and we are applying some transformation logic on that data, then put it in the sequential file(Target) with append mode. If we will get the wrong data from the soure, that data is also appending. we need some logic to ...

Hi Guru's, we have a issue with DATE feild column, From source we are getting varchar feild, this varchar is mapping to DATE feild in target. Due to source is VARCHAR, we are getting CHARACTERS for this feild but target is date field. due to this reason job getting aborted. For source field the data...

Hi,

we are replacing our old system(PROC) by datastage jobs.
In old system, for date field we are getting date from file name itself.
That file name format like this:A01yymmdd0.dat

In our data stage how we can handle this one?


Thanks in advance...

Jasti, I'm new to Datastage, I read in an article that we need to install the webservices pack for v7.5.1 and two Real time stages WS Client And transformer stage gets added. For ex i need to access the google search web service which uses SOAP api into our datastage job how should i go about. The s...

Can anyone who has used the webservices in DS Version 7.5.1 help me in knowing how to integrate the webservice into the datastage job.

Thanks in advance.

HI,

In query level, i used index hints and parallel hints, then that query fetching records fastely

Hi All,


Thanks for you'r inputs.

Hi Gurus, My source database is Oracle and one of the source query executed in 1 min in TOAD(Database tool) and that same query i putted in source oracle stage (job level) then for the extraction of data is taking nearly 50 mins. I am getting what may be the problem for this, can any one provide the...

Hi guru's, I am getting below error while compiling the job.please any one give any idea to solve this error and please tell me how to compile the parallel routine. Output from transformer compilation follows: ##I TFCN 000001 08:40:59(000) <main_program> Ascential DataStage(tm) Enterprise Edition 7....

ArndW wrote:Are there any more warning or error messages, particularly Oracle ones? ...

Hi ArndW,
Thanks for replay

I got the that only fatal error when i ran the job with that option.
with out using that option job is running fine. we are using that option for gain the performance