DSXchange

Hi, I'm trying to export and import some of the projects from dev to QA. The problem I'm facing is that in one of the jobs I have a transfer stage in which one field is right filled with #. So I have the command for transformation as "RFILL #". After exporting and importing this job, I'm s...

Hi, I'm extracting data from SAP R/3 using the Ascential Pack for SAP connectivity and I'm running into problem when the data type of the field in the SAP table is of type 'UNIT'. In this case, I'm not seeing the data properly once it is extracted. For example, if the field contains the value 'HR' i...

This is what I found in the qsrt manager log : ============ reading ADP FIELDS TO: OUTFILE ============ qsrtserv(14436):05/11/2005 09:37:35 AM qsrtserv(14436):05/11/2005 09:37:36 AM LOG: binding adp INPFILE:Step000 to callback function qsrtserv(14436):05/11/2005 09:37:36 AM LOG: binding adp OUTFILE:...

Hi, I have a QS job which I'm calling from DS using the QS-Datastage plugin. When I run the job directly from QS it gets executed under 1 minute. But when I run the DS job that calls this QS job it is taking about 10mins to complete the QS job. What could be the reason ? I'm trying to find duplicate...

What 'rshewale' says is right. Don't include that column in the stage at all. The SQL server will automatically update it.

Here is one example of what to do : ex: i/p o/p NUM ACC NUM ACC 1 xxx 1 xxx 1 xxx 1 xxx 2 yyy 3 aaa 2 xxx 3 aaa 3 aaa 3 bbb 3 aaa 3 bbb

Hi, I have the following requirement : From a file, if any two or more records have the same value in the customer number field(NUM), but have different values in the accout number(ACC) field then store such records in another file. Problem is that, if the i/p file contains 3 records for the same NU...

Hi,

Can anybody let me know the feature enhancements/additions between versions 7.0 and 7.5 of Qualitystage ?

Thanks,
nrc

Thx for all the help. I got what I wanted using the aggregator.

Hi, In a transformer stage, I have two output links. One writing to a hash file(link1) and another to update a table(link2). I want to update the table with the number of records written to link1 in the transformer. I want to do this after all the records are written to the link1. Any ideas how I ca...