DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 38 matches
Author Message
 Topic: Datastage Loading in Oracle table Speed
syedmuhammedmehdi

Replies: 8
Views: 125

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Oct 20, 2017 7:06 pm   Subject: Datastage Loading in Oracle table Speed
I'm not loading into the same table.
 Topic: Datastage Loading in Oracle table Speed
syedmuhammedmehdi

Replies: 8
Views: 125

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Oct 18, 2017 6:59 pm   Subject: Datastage Loading in Oracle table Speed
qt_ky

yes, it is exactly the same thing
 Topic: Datastage Loading in Oracle table Speed
syedmuhammedmehdi

Replies: 8
Views: 125

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Oct 18, 2017 6:50 pm   Subject: Datastage Loading in Oracle table Speed
Paul, yes, same stage properties
 Topic: Datastage Loading in Oracle table Speed
syedmuhammedmehdi

Replies: 8
Views: 125

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Oct 18, 2017 11:33 am   Subject: Datastage Loading in Oracle table Speed
I removed oracle target and kept dataset in new job after split, will that not give same transform duration? Actually and also in my old job by monitoring link stats at run time the job was just worki ...
 Topic: Datastage Loading in Oracle table Speed
syedmuhammedmehdi

Replies: 8
Views: 125

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Oct 18, 2017 9:52 am   Subject: Datastage Loading in Oracle table Speed
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi,

I'm loading one Oracle table with around 19 million records. I was checking speed of the process by making changes in the job. My job had a fetch query and some sort stages, remove duplicates, ...
 Topic: Ereplace function Missing in Parallel Jobs
syedmuhammedmehdi

Replies: 9
Views: 209

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Oct 18, 2017 9:33 am   Subject: Ereplace function Missing in Parallel Jobs
ok, thanks all
 Topic: Ereplace function Missing in Parallel Jobs
syedmuhammedmehdi

Replies: 9
Views: 209

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Oct 17, 2017 10:18 am   Subject: Ereplace function Missing in Parallel Jobs
v11.3
 Topic: Ereplace function Missing in Parallel Jobs
syedmuhammedmehdi

Replies: 9
Views: 209

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Oct 17, 2017 6:25 am   Subject: Ereplace function Missing in Parallel Jobs
Yes, it is missing. Both Change and Ereplace are missing, it is really strange here Sad
 Topic: Ereplace function Missing in Parallel Jobs
syedmuhammedmehdi

Replies: 9
Views: 209

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Oct 13, 2017 8:59 am   Subject: Ereplace function Missing in Parallel Jobs
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi, In my previous company we used to use Datastage v9 and v8.1 and in both of them our parallel job used to have function Ereplace but that in my current company we don't have Ereplace function inste ...
Resolved
 Topic: Oracle Connector - Oracle Bulk Load vs Insert
syedmuhammedmehdi

Replies: 2
Views: 261

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Oct 09, 2017 9:33 am   Subject: Oracle Connector - Oracle Bulk Load vs Insert
Thanks Chulett for reply.Actually, after some debugging I came to know that there was no slowness caused by bulk load but before Oracle Connector I was using transformer in which I was calling Oracle ...
Resolved
 Topic: Oracle Connector - Oracle Bulk Load vs Insert
syedmuhammedmehdi

Replies: 2
Views: 261

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Sep 25, 2017 9:00 am   Subject: Oracle Connector - Oracle Bulk Load vs Insert
DataStage® Release: 9x
Job Type: Parallel
OS: Unix
Hi, I'm loading 21 million records in a Oracle table and it is taking around 1 hr 30 Minutes to load using Oracle Connector. I used Bulk Load as well as Insert Mode in Oracle. Surprisingly, in both mo ...
Resolved
 Topic: Passing and Calulating Expression Dynamically
syedmuhammedmehdi

Replies: 5
Views: 352

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Sep 14, 2017 8:08 am   Subject: Passing and Calulating Expression Dynamically
Yes, Thanks Mike, I'm creating Temp Table in DB with those variables as column and then doing custom derivation in SQL and it is working.
Resolved
 Topic: Passing and Calulating Expression Dynamically
syedmuhammedmehdi

Replies: 5
Views: 352

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Sep 13, 2017 12:51 pm   Subject: Passing and Calulating Expression Dynamically
Hi Mike, thanks but please advise "bunch of nested if else" what do u mean?
Resolved
 Topic: Passing and Calulating Expression Dynamically
syedmuhammedmehdi

Replies: 5
Views: 352

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Sep 13, 2017 7:14 am   Subject: Passing and Calulating Expression Dynamically
DataStage® Release: 9x
Job Type: Parallel
OS: Unix
I'm getting following value of derivation in column flag_value from a table

if ((currentMonth <= 3 and ( ((mbrSubPlnAdjEndDt ="") or ((mbrEnrEndDtMonth >= 1) and (mbrEnrEndDtYear >= (curre ...
 Topic: Connector - After SQL issuing warnings
syedmuhammedmehdi

Replies: 1
Views: 986

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Oct 31, 2016 7:00 am   Subject: Connector - After SQL issuing warnings
DataStage® Release: 9x
Job Type: Parallel
OS: Unix
In Oracle connector stage I'm executing one After SQL after loading a table. I have set After SQL fail to "No". That is if the After SQL statement fails due to any constraint or any issue then job sh ...
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours