DSXchange

One possibility would be to create a source file with all the possible values, then use a lookup stage, and filter stage to filter those that were not found. HTH, Gaby Oops my bad! :oops: But the post by gabrielac is really amazing.. :D I am gona ask this question in the interviews.. and that's the...

Hi, As per the priyadarshikunal's post ,that is the points mention in the post , i have created a script which might help you to solve your problem. :lol: The script is : #!/bin/ksh DIRPATH=path of the directory #Assuming the directory is empty or running for the first time cntprev=1 #This script wi...

Hi, In the filter stage you can use '<>' along with 'and' operator. :) For example: Suppose in my fisrt link i want only those employee who Employee number are not in 2 and 6..then this logic can implemented i filter as : EMP_NO <> 2 AND EMP_NO <> 6 Output link=(link where you want to pass this reco...

Hi, I am not able to recollect the exact parameter name but i think it is: APT_DECIMAL_INTER_ROUND_MODE... :oops: or APT_DEC_INTERM_ROUND_MODE You can check the variable : APT_DECIMAL_INTER_ROUND_MODE=None. I am not able to check the result since right now i do not have the acess to DS. Hope this wi...

Hi, For this you can use folowing stages: External Source Stages-->XML Input Stage--> Transformation. First you have import the metadata defination using XML Table Defination. Check in all the boxes.... :o In the XML Input stage you have to select URL/File option in the input --XML Source tab.... :w...

You can use APT_PM_PLAYER_MEMORY parameter. :) Form the Advance Parallel Job Developer Guide: APT_PM_PLAYER_MEMORY This environment variable is available in the DataStage Administrator under the Parallel --> Reporting branch. Setting this variable causes each player process to report the process hea...

:idea: Boolean values don't need to be explicitly set - in essence they set themselves to true or false based on the expression. So... If IsNull(FldName_1) THEN '0' ELSE '1' Could be replaced with: Not(IsNull(FldName_1)) And then you simply reference the stage variable in the constraint to check fo...

ray.wurlod wrote:Send wads of money to IBM and they'll do it for you. ...

or you can assign it to me.. :D ...i will charge you reasonably..

Hi, You can use the following logic: 1.Use a stage variable to check Nullablity of your column...and then assign the value for nulls that is: IF IsNull(FldName_1)) THEN '0' ELSE '1'------------------------------->svr1 Then you can check in the constrinats: ((svr1=1) or (Trim(FldName_2) = 'ERSA' And ...

Hi, You can query the Datastage Database... :!: With help of DS Gurus.....i have created the query.....but not able to test it right now... :roll: Hope this will help you out... :wink: SELECT DS_JOBS.NAME FMT '50L'AS JOB_NAME, EVAL DS_JOBOBJECTS."@RECORD<15,1>" AS DATASET_NAME FROM DS_JOBS...

Hi,
You can use shell Script....
In that you can make use of "dsrecords" commmand to get the record count of Datasets..
dsrecords -n Datasetname

Hey! Before posting you should have gone through the below link...
It is amazing...

viewtopic.php?t=94948&highlight=Interview+Question

This error is due "not having permission to some developers".There are developer in different default groups...change everyones default group to 'dstage'... :) Details of different error codes are mentioned in kumar_s post in the below link: :lol: http://www.dsxchange.com/viewtopic.php?t=9...

You can use DB2 API stage to connect to i series....
Below link from IBM might help you out..

http://www.ibm.com/developerworks/db2/l ... index.html

keshav0307 wrote:Read the parallel job developers guide for change data capture stage

hmmm...You can also use diff stage to achieve this purpose...