DSXchange

Thanks Craig. yes it normally follows job annotation and job modification history. But by the time it goes to production, it is few days/month after job modification time. So we are missing something to track the job which deployed into production as part of deployment (we are getting list which goe...

Thanks PaulVL. I could not find the table -DATASTAGEX_DSJOBDEF However I found the table XMETA.DATASTAGEX_XMETAGEN_DSJOBDEFC2E76D84 where it stores the Job Created and Modified timestamp when the Job created and modified last time. The problem here, suppose a Job modified last time 1 month before in...

Hi Friends, I am trying to find out the Job deployment Date timestamp(when any job deployed to an environment) from XMETA database. Is there any tables/views which stores the DataStage Job/Sequences deployment time in that environment. This we are trying to find out for Audit purpose. Any help to fi...

Thanks James. The scenarios is like below: I have some derivation based on The Rate,Qty, Discount and then doing some percentage calculation. After that based on the [b]Currency precission[/b], I am doing the round up. By applying your math formula, it worked perfectly. Thanks a lot for all the help...

Hi Friends, I am trying to rounding of a Decimal based on a Parameter, which will give the length of digits after decimal points. When I am trying to use DecimalToDecimal() function, I need to use the Datatype as required, so I am not able to provide the Parameter for Rounding. Any idea how I can ro...

Hi, I want to Handle the MQ Connector Stage sequence while the sequence abort in the middle (while reading the Message from the Queue). Example: Suppose I have 100 messages in the queue and writing into a Dataset. If due to some reason the message queue failed after reading 50 messages, how I should...

The DataStage Server is started. Can you please tell me how to know whether the server is running or not? Also I was trying to Login the DataStage Client by using the Userid and password. It is showing error that ; "Failed to authenticate the current user against the selected Domain" I hav...

Hi,
We have re-booted the Unix server. Could anyone please help me how to restart the DataStage 8.0 Service to bring DataStage up?

Regards,
Pksahu

Thanks Craig. I added the ODBC connection string in the Project dorectory now. Sitll I am getting the same problem. The mesage is "DSR.MetaGeta(GET.DSNINFO)(SQLConnect('SRDNAVEEN','sa')): BCI Error:SQLSTATE=77,CODE=0,[DataStage][SQL Client][ODBC]523 76" Is there any other setup required fo...

Hi All, I am trying to connect SQL Server 2005 from DataSatge server. But I am not able to connect and giving the below error: DSR.MetaGeta(GET.DSNINFO)(SQLConnect('SRDNAVEEN','sa')): BCI Error:SQLSTATE=77,CODE=0,[DataStage][SQL Client][ODBC]523 76 I have added 'SRDNAVEEN' as ODBS string and added i...

Hi, I have one xml file with Header and Trailer at the same level. The Detail records below the header maintain parent-child relationship. Can anyone please guide me how to read and establish the parent-child relationship between those records. As the from date and tdate of the below file gets diffe...

Can you verify both datatype from the Aggregator output? Both should be same for a match. -pksahu [quote="Sravani"]Hi Ray, I/P File1-->TRANSFORMER--->AGGREGATOR--->COPY --->O/P1 > [b]JOIN[/b]--->O/Pfinal I/P File2-->TRANSFORMER--->AGGREGATOR--->COPY --->O/P2 In the above structure, I am ve...

Can you verify both datatype from the Aggregator output? Both should be same for a match. -pksahu [quote="Sravani"]Hi Ray, I/P File1-->TRANSFORMER--->AGGREGATOR--->COPY --->O/P1 > [b]JOIN[/b]--->O/Pfinal I/P File2-->TRANSFORMER--->AGGREGATOR--->COPY --->O/P2 In the above structure, I am ve...

Yoc can use the below formula:-

@partitionnum+(@inrownum-1) * @NUMPARTITIONS

Yoc can use the below formula:-

@partitionnum+(@inrownum-1) * @NUMPARTITIONS