DSXchange

Try using * at end of the command,

dssearch -ljobs -matches -sub -c Transformations SB3 *

Hello

We have a requirment where we need to anonymise data coming from source files.
can anyone please let me know the strategy to achive this through datastage

Thanks & Regards

Hi, My job look like Oracle enterprize (Oracle DB) - >Transformer -> ODBC (SQL Server) - Peek(for rejected) Target is daily refresh(truncate and load) This job complete sucessfully, some time it givies fatal error but job doesnt abort [DataDirect][ODBC SQL Server Driver]Communication link failure AP...

version number is 10.2.0

Hi
Can anybody tell will DataStage 7.5.2 supports 10.2.0.4?

Will there be any issue to already running jobs on 10.2.0.3 of oracle version?

Dear, do you really wanted to see that value? Is that job param / env var?

Thank you all for sending quick response and suggestions Design of my job:Before DS(3n) DataSet(5n)----Change Capture---(XfmTransform)---Oracle The issue has been resolved in below two ways 1. As before Data set for change capture stage created in previous day run with 3 node config file, recreated ...

Dear All, Job is aborted since there is change in config file from 3 node to 5 node. Job has been aborted with the below error message. can any body help us to resolve this.the same job has been executed successfully with 3 node. The number of partitions is already constrained to 5 --is this about n...

Hi
I have a requirement Where I need to Abort a sequence when the Current time reaches 7:30 AM, Means after 7:30AM Sequence should not continue, If it running It should Abort.

Please advise In this regard.

Thanks

Ray,

Other friends of mine conected on same server , And they are able to veiw properties of Oracle stage , But in case of mine DS client it is not working , DS client is getting hanged.

Hi ,

Whenever I am clicking on Oracle enterprise stage properties the DS client is getting hanged/struck.I tried re installing the DS client (Windows) but the problem still exist.

Please help in resolving this issue

Dear Gents I face new problem in one of my px job the error that comming is Message: XfmLoadBase24CcrAcctPartyRelationshipUpd. (fatal error from ): Internal error - missing script file RT_SC3501/OshExecuter.sh the job was working fine but in the last 2 days start to abort with last message please so...

Thanks Andrew We using number of tables from this source Database having US7ASCII NLS, We are not facing any problem with any of the table we are sucessfully able to load arabic data from source to target. other tables has data like this but these are able to convert to arabic in target dbOJZjjQGdeS...

Thanks for reply .. Data at the source look like this QxwTv +e )Se we Qv{wU 6vp R{e{ wew Qvq )~dhv 6vvaq we Ra (+{xwv~v '+ xUw We are able read and load from other tables from the same source But we are facing problem with only this table(above data having box in between) source database is US7ASCII...

Hi All, We need to load data from source system (Oracle) and NLS at source is US7ASCII ,To our target Oracle at source one coloum contain arabic data , we are facing problem in loading this coloumn please advise. We tried using below method 1) extraction from source table and loaded in DATASET passi...