DSXchange

Thanks for responding Chulett.

I tried above option but its not working

HI, i have job to get the data from oracle connector and doing some tranformations then finally it loads into SQL server using ODBC connector.This job is working fine as expected, but only concern is incase if the job fails in middile it inserting the partial data into SQL server table, have to dele...

Yes , all the six Sequels has different joins with different tables on TXN table , if all starts picks the records at a same time it can reduce 30 % of run time.

Yes , I ran that by putting copy stage i could see some improvement in elapsed time but its not fetching data parallel from all the six OCI stages, By looking at the performance stats i could see OCI stages not fetches data parallel y. All these six stages we have once common table called TXN_HDR us...

HI , I designed with 6 OCI stages and combines data for all 6 stages using funnel and loaded into a final table, how ever this job took 50 mins to complete execution. Actually here out of the six OCI stages initially first 2 stages fetches data renaming stages wait till completes that then next two ...

Hi, Can please some one explain process to convert russian characters to English in Datastage job? I am using Sql file stage to read source file with russian character. In the NLS Map tab, i am using UTF-8 to read the file. In the Target, again in Sql file stage, in NLS Map tab i am using KOI8-R. ou...

There is No limitation

You cannot see this option in Lookup stage, when you use the DB stage as a reference you can see this option in DB stage properties tab.

No, Sparse lookup supports for DB stages only

Hi All, Source Hash(SH)====>Xfm======>normalised Hash(NH)======>Target i had a job its reading the data from universe hashed file(SH) and writing it to another hashed file(NH), same hashed stage is normalising the data and load into final sequential file. But here i have around 3 billion records, jo...

is not there any other solution ???

Am working on server jobs, it does not have reject option in oracle stage

Hi, My target data base is oracle , i use OCI stage to load records , when i load the data its throwing warnings like ORA-01722: invalid number. i dont want to load these records into target , i want to load in reject file . when i give the constraint to reject link its loading the rejected records ...

Hi, Am calling the stored procedure in the oracle enterprise stage, with in the close command option CALL #$ESR_SCHEMA#.LOAD_UTILITIES.TRUNCATE_TABLE('HT_KNG_DIV_CLASS_LKP'); but its saying invalid close command,but this procedure is working fine when i call in oracel OCI stage in server jobs can we...

Hi, Am working on the version of datastage 8.1, am planning to write some batch scripts to that export datastage jobs. when i tried to search the dsexport command i could not see in my client machine . \IBM\InformationServer\Clients\Classic is not available in my client machine. please help out me w...