DSXchange

We tried with CurrPk=PrevPk in the loop condition and defining the PrevPK and CurrPk as stage variables and then defining a Loop Variable LoopVar to concatenate each recored with the previous concatenated value that is stored in the LoopVar. But, the loop is executed infinite times. Same thing is wo...

Hi All, Below is the scenario which we are trying to do using loop in 8.5 version. The functionality is achieved already using stage variables. We are looking for doing this in loop if possible. Input File PrimaryKey Data1 Pkey Data2 Pkey Data3 Pkey1 Data1 Pkey1 Data2 Pkey1 Data3 Output we want like...

Premium membership will allow you to view the entire contents, and receive other benefits too. Meanwhile, spend some time investigating what the Data Set Management tool can show you about segment files. I did check in the dataset management and the segment file paths. The data is stored in segment...

Hi, Below is the job design of a datastage job: Dataset-> Transformer-> Dataset With a 2 node config file will this job always create 6 processes or different number of processes. With APT_DUMP_SCORE can I see the exact number of processes in the log for this job. For what purpose APT_DUMP_SCORE can...

In Dataset Management while copying a dataset without giving any explicit path which location the dataset gets created. Also .ds is the descriptor file. Where is the actual location of ... I could not view the response. I am assuming that the resource disk path written inside the config file for ea...

chulett wrote:Then it sounds bug-like to me. What exact 7.x version are you running? ...

The client version is 7.5.1.

Regards,
Suman

ray.wurlod wrote:No.

Does this happen only on your computer, or for everyone at your site?

If it's just yours, try re-installing the DataStage client. ...

This is for all others not only with me.

Regards,
Suman

While doing conditional lookup sometimes after right click the input columns show disabled. When the lookup stage id replaced with a new lookup stage it enables the input columns. Is there any reason why sometimes it shows as disabled and sometimes enables.

Regards,
Suman

In Dataset Management while copying a dataset without giving any explicit path which location the dataset gets created. Also .ds is the descriptor file. Where is the actual location of the records in the dataset. Is it a single path or multiple path in the disk.

Regards,
Suman

The job is stuck in a filter stage inside the job and it is not doing anything after that. Filter stage is supposed to split the data into four different output links based on some condition. Is there any problem with Filte stage which is causing the job to hang. This job ran earlier with the same d...

Hi, We have a parallel job with many join stages and filter stage to split records based on some criteria. The job is running for more than 24 hrs without stopping. After the filter stage the job in designner is showing 0 records and in the Monitor in director it is showing running even after 24 hrs...

Is the key nullable in source file.If it is then change it to nullable in the table as well. This warning will go.

Hi, I have a job where i am comparing an oracle table and a sequential file. I have a key column and 2 columns (change values) for which the change needs to be detected. I updated the table with the records in sequential file. So, i deally when i run the job for the second time, all the records sho...

ray.wurlod wrote:

Suman wrote: The problem in the job is coming because of '&' in the input file name.

What proof do you have for this assertion? ...

Hi Ray,
When we are giving '&' in the filename then only the warning is coming. It is not coming when '&' is not given in the filename.

Regards,
Suman

Hi Amey,
We have already checked the links you have given. We tried with changing APT_MONITOR_SIZE and APT_MONITOR_TIME values. The problem in the job is coming because of '&' in the input file name. We want to know how '&' is causing this problem.

Regards,
Sumanta