DSXchange

This can be done in the following ways also. 1) Load the entire data using WRITE METHOD in Oracle Enterprise stage . Call the shell script in After Job subroutine , for re-building the indexes. Note Your shell script should contain ,connection script to the oracle environment and also alter index re...

hi, Try giving 'DROP' option , If not Found of the lookup stage , if there is no match in your look up table you will not get any warnings or your job will not got aborted . But any how from the lookup sparse table link you will have the exact number of rows it looked up . Only the output link retur...

Hi, There is no straight forward logic to your question i believe , but i can give a suggestion where u can achieve it through data stage. 1. Assuming you are having the data in a source table/File . Define Key column as key from the source stage. 2. Have another temporavary table with 2 columns . S...

Hi Maharaj, This was due to the following reason. I think u r using oracle enterprise stage. What about the commit frequency u have specified in the enterprise stage. R u commiting single record ? Or multiple records ? If you are commit frequency is greater than one in the stage , then the following...