DSXchange

yes Ray it works with a word DISTINCT in the Derivation cell of the first column in the Columns grid

hello friends, what is difference related to Dynamic_RDBMS stage and Oracle OCI stage. i mean to say is there any performance gain using Dynamic_RDBMS over Oracle OCI stage or vice-versa, as for example taking oracle database into consideration. i am curious as i can do all action in Dynamic_RDBMS s...

hello,

in your Dynamic_RDBMS stage use "User-defined SQL" and write a sql statement like

'Select distinct column_name from your_table_name", with proper column mapping with your sql statment.

it works fine eliminating duplicate records, just try.

hello, i think you need to write a custom routine which needs to be used in "After-job Subroutine"(Job properties), which will track your job status and write an information in log file. Main function to be used is DSGetJobInfo with InfoType=DSJ.JOBINTERIMSTATUS. DSJ.JOBINTERIMSTATUS. Retu...

hello, what i understand from your quotes is that you need to set values for all job-parameter used in your jobs, plus when you change the values stored in database, it should use these new values. 1. First let your basic code read either a database or a file in which you will maintain username/pass...

hello dear please remove your column name for which you want to use a sequencer from column tab but in your user-defined sql statement do mention column name and its sequencer with proper order.

You can use EXECSH as after job routine and give entire path of the script file you want to execute.

hello,

please post your error message that will give us a clear view of what is an issue.

plus you can check your environment settings to access database from data stage client especially PATH variable.

hope before processing this file you can use unix sort command ........

hope before processing this file you can use unix sort command ........

if you have a pdf file "XMLPACK_20_Designer.pdf", this can help you, please check properly how to set XPath expressions according to your requirement.

hello dear, job design database---->T1---> hashfile lookup from hashfile to transformer T2 (equi join constraint) inputfile-----> T2-------------------->Oci-stage(User-defined Sql) you need to first find distinct Cust_Id from database into hash file, then put a constraint into transformer to get equ...

in one transformer you calculate sum of two columns and in second transfomer's constraints, you can make a decision of job processing.

one of the datastage doc explains like This Isolation level provides the necessary consistency and concurrency control between transactions in the job and other transactions for optimal performance. Because Oracle does not prevent other transactions from modifying the data read by a query, that data...

please check for your repeating element and its description(XPATH expression).