DSXchange

Hi All,

Can any one help me by sending "Unit Test Script" Template for any of the DSProject..

please send one [b]Unit Test Script template[/b],but not "Unit Test Plan Template"..

please send to archanaps2001@yahoo.com


Thanks..

hi, i am using "Truncate table,then insert rows" as loading strategy in target stage.. i am using DRS stage for the target and source. it is a fact table job,simply loads from source to target.. my job design is : DRS(Source)------>IPC(Inter Process)........>Trasfrmr........>IPC.........>D...

Hi Arndw,

Thanks for the response.

Can you explain in detail that ,"recode your job to not attempt an insert on an existing record"

how can i achieve this?

thanx in advance

hi, when i am trying to load a sqlserver table using DRS stage,i am getting error like " j_Fact_xxx..DRS_xxx.IDENT1: [Microsoft][ODBC SQL Server Driver][SQL Server] Cannot insert duplicate key row in object 'PS_F_xxx' with unique index 'PS_F_xxx. [Microsoft][ODBC SQL Server Driver][SQL Server]T...

hi ray, it is not refering to non-existent input column.i am getting problem at [b]PIVOT stage-ouput-coloumns-derivations [/b] and i am also getting fatal error message like, "P__xxxx..IPC_SRC.DRS_xxx_in: ds_ipcput() - timeout waiting for mutex" can you direct me to solve this! thanks

hi all, i am getting problem with a sequencer(which calls 2 jobs). when i tried to run that 2 jobs individually they are running fine,but when i try to run the sequencer,it is getting aborted.. error message like: Cannot map output derivation of column 'xxxx' to any input column. can any one direct ...

hi all,
i am new bie to datastage,,

i am getting following error,when i open a job and trying to compile it..


"Cannot get exclusive access to executable file for jobxxx.job may be being monitered"

can any one please explain the problem?

thanks in advance

Hi All

Im getting the following error while trying to view data in a DRS(Dynamic RDBMS stage)


"Jobname: Unknown client library - $PROJDEF
Jobname: DSP.Open GCI $DSP.Open error -100."

Can anybody tell me what exactly is going wrong?

Thanks in advance

Diya

I have to use a parallel job as I have to generate multiple xml files in a single job which includes Joiners also..
I just want to know the Function which a Normal Transformer supports this Replacing instead of Using a Basic Transformer to implement this replacement

I am using the CHANGE function now.Could you please tell me the syntax for EReplace in this case to replce an '&' character

Hi all, My Job generate xml files from csv files. As xml file will not recognize '&' char ,I need to repalce it with '&' Now I am using change Function which is there in Basic Transformer. But this is causing lot of troubles while running .The processs are getting locked very frequently. Is ...

I am using a Look up instead of outer Join..Matching records will pass thru the stream to the next stage and the unmatched records are captured thru the reject link to the Exception File

I am creating some set of xmls and certian Exception (csv) files based on certain rules. Role_id is the key in the lookup.Based on the join between two files I need to capture both matching coloums and unmatched coloums... I am not able to trace by that error given ,in which stage of the job ,actual...

No it is not repeating in the Lookup

Hi, while Running the Job I am encountering the following error. The Job generates xml files from several input files.I need to add some exception files also when the perticular condition fails. After I added the Exception files by placing the reject links in Look ups-- I got the following ERROR Is ...