DSXchange

Hi, I'm getting the following warning.I hv checked for input/output filed lengths.They r correctly mentioned. But i don't know why this error is coming. Message: IWD5A014Part3..IWD_CLM_LINER_Seq.IWD_LNR_OP_Lnk: nls_map_buffer_out() - NLS mapping error, row 1 (approx), row = "```8003694686000000...

Hi,

I'm trying to open one of my jobs but it say its being accesed by other user.
But no one is using it.I tried releasing locks/logout options but nothing is working..... Pls help me out

I would like to know how to kill it or release locks in a detailed way...

Hi, My DS server is too slow.I hv a doubt in my client also. My job consists of 60 transformer stage,10 link collectors and 60 look-ups. It takes 15 min to compile.10 min to open the job itself.I'm really frustrated dealing with this. What might be the pbl. ? My DB is SQL SERVER. Only three person a...

Hi, I am using an aggregator in my job.The no. of fields is around 200. I want to do a aggrgate funtion(Last) on some 10 fields.But DS expects all fields need to be done atleast one aggregate function.Since more number of aggregators are to be followed,making every field an aggregator function is to...

Hi , I'm getting the following error msgs in the link collectors i hv used in my job.This is the first time i'm using link collector.So i don know how to clear the errors. "Transformer_201.DSLink238: ds_ipcopen() - call to OpenFileMapping() failed - The system cannot find the file specified.&qu...

Hi , While i'm working in the transformer stage i get the following messsage " DSDesigner.exe generated errors windows closes the pgm " After this i'm forced to end the DSDesigner. At times i get the following error also: " Sub-Script out of range " What might the problem & a...

Hi

Will the perfomance of a job get affected if we use link collectors ?

We are about to use some 10 link collectors in out job which handles huge volume of data.

Hi ,

How to delete a hash file using DS or DSCommands ?
I am temp. using hash files in a job.I want to delete those files after finishing the job.
Is there any way i could do it in the same job itself ?

Hi,

Is there any Shared Variable/Common Variable concept ?
My idea is i want to use a variable in tow transformers without carrying it from one transformer to other transformer.Is there any thing called common variables ?

Hi ,

Atlast solved the Pblm !!!!!!!!!!!!!!!


If v by-pass the user name,Password authentication while logging in to DS we get this error.
If v give those stuffs and proceed v r able to save it.

I don't understand wat diff. it makes. !!!!!!!!!!!!!

Hi ,

Atlast solved the Pblm !!!!!!!!!!!!!!!


If v by-pass the user name,Password authentication while logging in to DS we get this error.
If v give those stuffs and proceed v r able to save it.

I don't understand wat diff. it makes. !!!!!!!!!!!!!

Hi ,

Atlast solved the Pblm !!!!!!!!!!!!!!!


If v by-pass the user name,Password authentication while logging in to DS we get this error.
If v give those stuffs and proceed v r able to save it.

I don't understand wat diff. it makes. !!!!!!!!!!!!!

Hi , Is there any limit on the length of column names used in DS from an input ODBC ? OR Is there any limit on the number of columns used in DS from an input ODBC ? My prob is i'm unable to save my job in which i used 290+ fields. It saves the job until i use 200 fields,after that it says : Error ca...

Hi,

My Datastage designer is giving some problems.

1) Its not opening at times.Gives a message Invalid Picture.
2) The job i'm opening shows a msg - DSObjects not found.Unable to retrive the links. The job links are not there.

Anyone could help me in this regards.

Hi, I hv to select records from various tables. I can use SQL Join query or use look-up to acheive this. The volume of the records is in millions. The count of the tables i'm going to use will be around seven. Which of the following is a better option ? Using a join query or using ODBC look-ups.