DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 45 matches
Author Message
 Topic: ODI Vs DS
iHijazi

Replies: 12
Views: 28274

PostForum: Data Integration   Posted: Mon Apr 08, 2013 8:03 am   Subject: ODI Vs DS
Excellent points!

Thanks for sharing.
 Topic: ODI Vs DS
iHijazi

Replies: 12
Views: 28274

PostForum: Data Integration   Posted: Fri Mar 01, 2013 8:27 am   Subject: ODI Vs DS
Thanks chulett!

I do understand how ODI actually works. Having it writing PL/SQL only works with Oracle DB, other DBs have different scripting which ODI support accordingly. Plus, I think this is a ...
 Topic: ODI Vs DS
iHijazi

Replies: 12
Views: 28274

PostForum: Data Integration   Posted: Fri Mar 01, 2013 6:23 am   Subject: ODI Vs DS
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hi folks,

I'm currently doing a research to understand the major differences between:
IBM Balanced Optimization and Oracle Data Integrator approach.

"Balanced Optimization approach is comparabl ...
 Topic: Match Designer - Comparision Types
iHijazi

Replies: 1
Views: 1850

PostForum: IBM QualityStage   Posted: Thu Oct 11, 2012 4:08 am   Subject: Match Designer - Comparision Types
DataStage® Release: 8x
Job Type: Parallel
OS: Windows
So if you have records which are something like this:


ID NAME IDS
--- ------- ------
1 Issam 649874 54898 3128A 848E
2 Issam 3128A
3 ...
Resolved
 Topic: Duplicate Job Recommendation
iHijazi

Replies: 1
Views: 1898

PostForum: IBM QualityStage   Posted: Thu Oct 11, 2012 3:03 am   Subject: Duplicate Job Recommendation
Well, since no one tried to comment on this, I think I'll go with my logic Smile

Steps:
1. Prepare test data, if you have millions, it would be good idea to generate something around 25,000 or more. ...
Resolved
 Topic: Match Designer - Unduplicate - Table Create Failed
iHijazi

Replies: 2
Views: 2977

PostForum: IBM QualityStage   Posted: Sat Oct 06, 2012 10:50 pm   Subject: Solution
Hi,

I finally found the solution. This line was my main clue:
"Could not get mapping for one or more datatypes. Cannot create table:SPEC_1_FREQ_PROPS_DATA"

I change ODBC driver and used "IBM Or ...
Resolved
 Topic: Duplicate Job Recommendation
iHijazi

Replies: 1
Views: 1898

PostForum: IBM QualityStage   Posted: Thu Oct 04, 2012 2:11 am   Subject: Duplicate Job Recommendation
DataStage® Release: 8x
Job Type: Parallel
OS: Windows
Hello guys,

This is not an issue related post, but more to suggestions on what you think the best approach is.

We have a table about 60+M records, and the client needs to have some statistics ab ...
Resolved
 Topic: Match Designer - Unduplicate - Table Create Failed
iHijazi

Replies: 2
Views: 2977

PostForum: IBM QualityStage   Posted: Thu Oct 04, 2012 2:02 am   Subject: Match Designer - Unduplicate - Table Create Failed
DataStage® Release: 8x
Job Type: Parallel
OS: Windows
Additional info: Oracle DB as Source and Target
Hi,

I am have some difficulties in the Match Designer. When I fill up the Test Environment needed values, and click on Update I receive "Match Designer configuration update process failed".

Full ...
 Topic: InfoSphere 8.5 FP1 - any major known issues?
iHijazi

Replies: 11
Views: 2799

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Oct 20, 2011 12:32 am   Subject: InfoSphere 8.5 FP1 - any major known issues?
Major, No.

Minor, yes.

Workarounds, there is.

In the end it's all about what you use. But I recommend using it (upgrading if you are an 8.1 user).

It's always fun to fix issues Smile

Cheer ...
Resolved
 Topic: DS 8.5 (FP1) and TD 13.1
iHijazi

Replies: 5
Views: 4076

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Oct 03, 2011 2:14 am   Subject: DS 8.5 (FP1) and TD 13.1
Another solution:

Use Teradata Transporter 12 libraries, that is, by pointing to 12 folder of Transporter. ONLY transporter.

This workaround has been accepted by IBM, since they are still workin ...
Resolved
 Topic: Fatal Error: Duplicate name registration for ...
iHijazi

Replies: 0
Views: 1505

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Oct 03, 2011 2:08 am   Subject: Fatal Error: Duplicate name registration for ...
DataStage® Release: 8x
Job Type: Parallel
OS: Windows
If anyone is facing the folloing issue

main_program: Fatal Error: Duplicate name registration for: changeapply, APT_ChangeApplyOperator.

main_program: orchgeneral: Could not ...
Resolved
 Topic: RDBMS code 5510: Invalid session mode for procedure ...
iHijazi

Replies: 0
Views: 2466

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Oct 03, 2011 2:06 am   Subject: RDBMS code 5510: Invalid session mode for procedure ...
DataStage® Release: 8x
Job Type: Parallel
OS: Windows
Additional info: Teradata
Hi,

If anyone faced this issue:
RDBMS code 5510: Invalid session mode for procedure execution

Here is the solution:
Although the Teradata API stage was not designed to invoke Teradata macros, ...
Resolved
 Topic: DS 8.5 (FP1) and TD 13.1
iHijazi

Replies: 5
Views: 4076

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Sep 27, 2011 2:35 am   Subject: DS 8.5 (FP1) and TD 13.1
As expected.. Logs, try to run this manually.. Blah blah..

Had to find the hard way, happy it got resolved.

Solution:
1. Rename (to anything, for backup purposes) telapi.dll, telapi.lib and msv ...
Resolved
 Topic: DS 8.5 (FP1) and TD 13.1
iHijazi

Replies: 5
Views: 4076

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sun Sep 25, 2011 10:39 am   Subject: DS 8.5 (FP1) and TD 13.1
*sigh* This makes me sad craig, and makes my day tomorrow very predictable!

Not that not only luck you need to get some real help from IBM, but also LOTS of time.. They'll start asking for logs, t ...
Resolved
 Topic: DS 8.5 (FP1) and TD 13.1
iHijazi

Replies: 5
Views: 4076

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sun Sep 25, 2011 7:51 am   Subject: DS 8.5 (FP1) and TD 13.1
DataStage® Release: 8x
Job Type: Parallel
OS: Windows
Additional info: Windows 2003, error on Bulk Load
Hi,

My client has updated TTU from 12.0 to 13.1. Didn't face any issue, and all went smooth. However, when running jobs involving TD, they got error as you see below. I made a test job, and noticed ...
 

 Jump to:   



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