DSXchange

thanks a lot..i was able to do it..

hi, i could give the SQL statement in the SQL tab but it it not accepting the table name from that statement. it is giving me the following error while i try view data:- testvalidity..Oracle_OCI_61: Table Name is a required link property for Link DSLink1 testvalidity..Oracle_OCI_61.DSLink1: DSP.Open...

Hi,
i am new to server jobs. i am not seeing any tab where i can mention the table name in oracle OCI stage. what am i missing here?

i used quotes and i removed the spaces around the "=". No i am getting this error.

Error -3 getting information for parameter 'INSER_SQL'

Status code = -3 DSJE_BADPARAM

hi, i am passing insert , update statements as parameters in a job. When i run it through director, there are no issues. But when i try to run it through command prompt via a dsjob command, it is giving me the following error:- ksh: 0403-057 Syntax error: `(' is not expected. my command is like this...

Hi,

I want to extract all the derivations in a transformer into an excel sheet. i.e i want to make sure that the mappings are correct, by providing this excel sheet. Is this possible?

Hi,

I am not able to view the pids of jobs in the director via "Cleanup Resources" options. It shows blank..it is happening in only one particular environment(i.e test). other environments such as dev are showing up the process ids. is there any setting to be done?.

hi, i had posted this after searching the forum..but was not able to find any solution. As i am dealing with the 'Progress' database which i am connecting through ODBC i would not be able to use any environmental variables like ORA_COMMIT_INTERVAL etc.,

Hi,

Is there an option to commit rows in a table through ODBC stage after 'n' number of transactions? Since our input data is large it is timing out in the odbc stage.

Hi, All the null values are handled, but still the issue persists. I changed the Oracle setting to "Insert then Update" and i am not having any issues. Earlier i had used "Update then insert" . But i am updating with the key which is the unique index of the table. Any ideas wh it...

Hi, I have a job where i have two inputs. One sequential file and one Oracle table. I do a change capture and then insert/update the new/changed records in the same oracle table(source). I am encountering an issue here. When i run the job for the first time, all the records in the sequential file ar...

Thanks. i assigned some default values to null and it worked.

Hi, I have a job where i am comparing an oracle table and a sequential file. I have a key column and 2 columns (change values) for which the change needs to be detected. I updated the table with the records in sequential file. So, i deally when i run the job for the second time, all the records shou...

The job is running in single node

Hi,

I am updating a target table taking the records from source. There are 10 records in the input file . So, ideally the number of records updated in the target table is 10, but the log shows that 20 records are updated. what could be the reason.