DSXchange

The database is in development environment.
No other application is running at that moment other that datastage job.

Hi All, I have created one sequence, where independent jobs are running parallely(no dependency link). In the sequence I will have max 100 db2 connection at a time. Total no. of connection is set to 200 on db2 server. But sometime I am getting following error. POD_Elc_Load_Mst_Hist_Audit..DB2_Read_S...

Hi all I rows something like this A B C D and i want it like A B C D iam trying to use a pivot but i am getting the output same as that of the input. I am not able to see any options in Pivot so that i can change. It is having just the STAGE,INPUT and OUTPUT.Where can i set the things which will wo...

What are the datatypes of those columns,
If these are varchar then some time don't match due to trailing blank space.
In that case use trim(field1) function in Key Expression.

Hi, I am encountering following error while login in DataStage version 8 using Designer Client/Director Client though i pass correct login and password Failed to authenticate the current user agains selected Domain: datamigtest:9080 Could not connect to server[datamigtest] on port [9080] I checked f...

jeawin
Is your job automated for every job for a project?

Can you please share logic of your job

Good post!
I was also thinking to post the same.

Thanks georgesebastian

DSguru2B ,
Since Peter is already getting time in milliseconds,
I think he needs to multiply with it to get seconds, not divide.

Is any row getting rejected due to truncation?
What database are you using?
There might be data issue like junk character.

Check some sample source data

We have a problem (7.1 windows). We lose all our connections from designer and director (error 81002). But when we stop and restart the services, DSRPC restarts but the other two services won't restart. In this "not started" condition I was able to open jobs using designer and compile and...

ray.wurlod wrote:Your job design needs three lookups, not one. ...

that means if hash file have data like following then we need 4 lookup?

LOOKUP1
A1
A2
A3
A4

You need to define the variable in your job as a parameter. Go to parameters and import it from your environment variables. Then you can pass it a value with dsjob.exe. Did you create the config file using DS Manager? DS Manager allows you to test your config files . Could u plz let me how to creat...

Are you saying tht the lookup can have A1 , A2 and A3 at the same time? or a single value? If it has all the values then what should be assigned to the output? If only one is present in the lookup then here is the way u can handle it -- Create the Hashed file with two columns - One column Substring...

What is the output u want from the job? As per ur data, there there is 1 rows in source and in the hash file there is matching row. The basic rule of using hash file as a lookup is that u need to have one key field in it which will match the source(driving table) table's field. If u elaborate and gi...

Thanks Ray, Actually I wanted to know about parallelism of server job. Correct me if i am wrong, now as per my understanding,if we have multi-processor system, then we can utilize the advantages of parallelism for server job. For single processor system, we can't get this advantage,because behind th...