DSXchange

sort on key columns on which you want to find duplicates using a sort stage and set create key change column as 'yes'. Then use a filter or transformer stage by using following condition: 1. key change column =1, put this constraint in master output link (unique records) 2. key change column =0, put...

Allocate chain number to each chain and then generate surrogate keys for chain numbers.

I changed configuration file (from one node to two nodes) and it solved this issue. Now all Qsmatchsetid values in duplicates are present in master records.
Please note that there is no change in number of records. I'm getting same number of duplicate and same number of master records.

reposting my question in different words.
Is there any way to find the master record for each duplicate record which are created using unduplicate match stage?

Use Asinteger function.

Hello Everyone, I have a query regarding unduplicate match stage. I'm collecting three outputs from this stage - Master, Duplicate and Residuals. My assumption is every Qsmatchsetid of duplicate records should be present in set of master records; however, I'm finding few Qsmatchsetid from duplicate ...

yes, you can have multiple start and end loop activities.

IBM support group has also confirmed that there is a limitation within Windows which stops users that are not apart of the administrator group from using this service.

I double checked and my user has full access on AT.exe file. One of the windows forum says that user should be in 'Admin' or 'Backup Operators group' to be able to schedule any task in windows. I added my datastage user in 'Admin' group of windows server and datastage scheduler worked. Note: When I ...

Thanks Ray. I moved windows one ahead of MKSToolkit in environment path variable. Now error message has changed and it gives following error: "Error Adding to schedule: Access is denied Command was: %SystemRoot%\system32\AT 11:00/EVERY:M,T,W,Th,F,S,Su vmdsr_sched.exe" But my user has full ...

Hello Everyone, Our datastage server is running on windows server 2003. When we try to create any schedule through director, it gives following error: "Error adding to schedule: You used an option with an invalid value. (Command was: %SystemRoot%\system32\AT 11:00/EVERY:M,T,W,Th,F,S,Su vmdsr_sc...

thanks Ray

yes. I_DS_STAGETYPES exist in this project. As you suggested, 'OVER.30' is not present in this directory. > ls -lrt total 68 -rwxrwsr-x 1 dsadm dstage 311 2007-08-28 17:22 INDEX.MAP -rwxrwsr-x 1 dsadm dstage 16384 2007-08-28 17:24 INDEX.000 -rwxrwsr-x 1 dsadm dstage 32768 2007-08-28 17:24 INDEX.001 ...

Not able to insert into DS_STAGETYPES:

DBidxupd: Unable to write overflow buffer in AK file "/u01/np1/app/dstage/PS_STAGETYPES/INDEX.001".
FATAL: Unable to do commit of record "TEST" in file "DS_STAGETYPES/DATA.30"

results of these queries are: 1. COUNT DS_STAGETYPES ==> 167 records counted. 2. UVFIXFILE DS_STAGETYPE ==> Beginning TRACE of DS_STAGETYPES TRACE of DS_STAGETYPES completed Warning: file load discrepancy detected. Scanning overflow buffers. Scan complete. 35 group(s) processes. 48 group buffer (s) ...