DSXchange

I am having the same problem as well.. i have a oracle enterprise stage reading source data from a table.. but before i read the table, i want to perform an update on the records.. so i give the update statement in the OPEN command option.. as 'update table_name set cur_ind='Y' where <condition>' i ...

I have 3 independent jobs 1) Reads source data into dataset1 and existing target data into dataset2 2) The 2 above datasets are input to a change capture stage and the differences captured to a dataset3 3)Read dataset3 and apply changes via a transformer/filter When i run these 3 jobs independently ...

We are implementing SCd and for every modified record that comes in from source, we have to insert new record in target and update the existing record with end_effdt and flag. Using the CDC stage that has both source data and existing target table data as inputs (in datasets), the output seems to sh...

If no one seems to have this job open, but still you get this error, you dont have to restart DS server, you can just RESET so these orphaned processes/locks get released. Issue a "uvadmin -reset", when logged in as DS admin on UNIX Asking rest of team members to save work and close applic...

Your design is like this SF ->Transformer-> Oracle stage. In the transformer, add a dummy column SEQ_ID and set it to a default value of 1. Then in the target stage, go to the SQL code and from the SELECT statement generated, replace the text 'ORCHESTRATE.SEQ_ID' (something like that - that is gener...

You can use DateTimeStampToOraOCIWithTime(DateGenericToTimeStamp(link.inputcolumnname)) in the derivation - it should insert the right timestamp in the oracle target column.. This works for me

Ray, how would be set the value returned from Oracle job/table to the userStatus variable.. pls advise

thanks

Thank you all for your very helpful replies. I will try the Merge and also the Aggregator Stage as kcbland has suggested and choose based on which runs faster.

I need to merge 3 fixed width sequential files with about 15 currency fields each and have approximately 1.5 million records which may or may not be sorted on the key values. The number of records may slowly grow over time. I need to untimately combine the 3 files to be loaded into a staging table. ...

I figure out you use the ExecCommand. There might be other ways as well. But, how do you pass the parameters in the command line....? Here is my command line: dsjob -user -password -run -mode RESET -wait fazr LeadsNightly_Hash How do you pass the parameters , which a Enviroment Variable Parameters ...

If you are asking if we can call the unix shell script as an after job routine, YES, we can do it go to job properties page..There you will see After-job routine drop down list.. select 'ExecSH' and in the input value text box - give the pathname and name of shell script along with arguments u want ...

DateTimeStampToOraOCIWithTime(DateGenericToTimeStamp(link.inputcolumnname))


this should work with a generic input timestamp.. and when the target is a oraOCI stage

ramana,Can you post the error messages starting from the first fatal error msg in the log for this job.. it would better help us understand the source of this abort.

i have the reject row checkbox ticked.. and no constraint defined on the links to the oraOCI stages - this reject file is just for a catch all

yes, I did