DSXchange

No! I am sure that at this moment only me is log in! I've checked it by

netstat -a

and *.dsrpc is LISTEN

Hi! I can't start DS derver on Unix. I'm getting following info: Unable to open NLS install directory "". Unable to get National Language Support shared memory segment. Unable to get National Language Support shared memory segment. Unable to get National Language Support shared memory segm...

You can use it as default in every project - just turn it on in DS Admninistrator for projects in which you want to have this funcionality

Hi! I am using transformer to divide one input strem into four outputs. Order of my output links is as following: 1 output writes data to hashfile1 2 output inserts data into database table1 3 output updates data into database table1 4 output modifies data in hashfile1 I want that any changes in dat...

Thank you for all comments!

Regards

Hello everyone! Today, I have been looking on "NewTemplateFromJob" option in DataStage. I can create job template and then use it, but (as I can see) template is only sth. like job copy stored on my client's machine or I don't understand template logic in DS. Is there some way to parametri...

DRS stage also using ODBC data source to get access to database!

Hi!

Is it better to calculate CRC (used for catch changes in source database) before any transformations need to be done on source data, after or doesn't matter?

Regards

what are you using to access to source and target?
na ODBC stage?

if yes, and your server is Microsoft SQL Server try to add proper code page option to your DNS source
i.e AppCodePage=1250

thanks for opinion elavenil! This is the only opinion so I assume that my first logic is the best way to solve this issue

regards

Hello! I want to implement hybrid SCD. Some fields in my dimension are type 1 and some are type 2. I am using CRC matching to detect changes. Then I want to proceed with type 2 changes and then I want to update all type 1 fields matching on source PK. What is my question? When I match CRCs I know th...

Yes, you have right Arnd! My nistake! Thanks!

roy, thanks for sugestionn , but this is not my problem! NULL detection (isnull() or Len(Trim(Link.col))=0) works fine !! But I don't want that rows with NULL detected goes to output1!! But they goes!! I don't know why!

Hello everybody! I have following issue: I want to test if input column1 is null, if yes I want to reject column (I do not want to have it in my output1) I have transformer stage with 1 input and two outputs, also I have constraint defined for two outputs: output1: IsNull(DSLink1.col1) output2: REJE...

Thanks Ishort! It is very smart idea