Thanks for responding Chulett.
I tried above option but its not working
Search found 222 matches
- Sat Mar 07, 2015 10:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Autocommit
- Replies: 4
- Views: 4416
- Fri Mar 06, 2015 10:20 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Autocommit
- Replies: 4
- Views: 4416
Autocommit
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...
- Sat Aug 23, 2014 11:08 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Performance issue in funnel
- Replies: 6
- Views: 4429
- Fri Aug 22, 2014 9:46 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Performance issue in funnel
- Replies: 6
- Views: 4429
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...
- Fri Aug 22, 2014 12:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Performance issue in funnel
- Replies: 6
- Views: 4429
Performance issue in funnel
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 ...
- Tue Mar 05, 2013 8:56 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Russian to English Conversion
- Replies: 1
- Views: 1740
Russian to English Conversion
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...
- Tue Feb 12, 2013 5:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: max how many stages we can use in single parallel job
- Replies: 4
- Views: 3097
- Tue Feb 12, 2013 4:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sparse Lookup
- Replies: 5
- Views: 3334
- Tue Feb 12, 2013 3:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sparse Lookup
- Replies: 5
- Views: 3334
Re: Sparse Lookup
No, Sparse lookup supports for DB stages only
- Tue Dec 18, 2012 3:11 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Hashed file performance issue
- Replies: 1
- Views: 2173
Hashed file performance issue
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...
- Tue Sep 18, 2012 4:36 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Capture reject records
- Replies: 7
- Views: 5080
- Tue Sep 18, 2012 2:41 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Capture reject records
- Replies: 7
- Views: 5080
- Tue Sep 18, 2012 2:04 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Capture reject records
- Replies: 7
- Views: 5080
Capture reject records
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 ...
- Thu Aug 30, 2012 1:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Call Stored procedure
- Replies: 1
- Views: 2087
Call Stored procedure
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...
- Thu Aug 09, 2012 12:25 am
- Forum: General
- Topic: dsexport.exe file not available
- Replies: 1
- Views: 1775
dsexport.exe file not available
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...