DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 587 matches
Author Message
 Topic: Lookup with a Like Operator
rameshrr3

Replies: 4
Views: 167

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Apr 19, 2017 10:01 am   Subject: Lookup with a Like Operator
I think you can use the same lookup stage - the reference link can be copied into 4 different ref links using a copy stage, and then use the approrpriate condition/scenario in each , drag all the resu ...
 Topic: Writing multiple record types flat file
rameshrr3

Replies: 5
Views: 206

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Apr 11, 2017 11:17 am   Subject: Tricky but very very do-able.
Yeah - custom sorts and subsorts are what i could think of , give we implemented the very complex PVF Files for DTCC which are Hierarchical Flat files better suited for cobol based programming or Webs ...
Resolved
 Topic: Group by clause implementation in Datastage
rameshrr3

Replies: 6
Views: 494

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Feb 09, 2017 11:41 am   Subject: Group by clause implementation in Datastage
From TEXT
Where TEXT.OID = 2498
And TEXT.TEXT in ('Discharge', 'Expired')
Group by TEXT.OID

If they were using SQL , a group by would not be needed
Resolved
 Topic: Group by clause implementation in Datastage
rameshrr3

Replies: 6
Views: 494

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Feb 08, 2017 6:52 pm   Subject: Group by clause implementation in Datastage
Only one group - since TEXT.OID is filtered on single value ? Whats the point - curious
 Topic: Identifying Basic transformer stage
rameshrr3

Replies: 4
Views: 362

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Feb 08, 2017 6:40 pm   Subject: Identifying Basic transformer stage
I usually use an icon editor or image processing tool to change the default look and feel of basic transformer on canvas , so that I know Smile
On my canvas the Basic transformer now has the similar ic ...
 Topic: Oracle ODI Vs DataStage Balanced Optimization (Part 2)
rameshrr3

Replies: 9
Views: 3974

PostForum: Data Integration   Posted: Thu Apr 14, 2016 6:02 pm   Subject: Oracle ODI Vs DataStage Balanced Optimization (Part 2)
Does the internal version of datastage engine have anything to do with the versions of the Universe Engine being release by Rocket UV ? Because the currently marketed version of UV is 11.x. I had an ...
 Topic: Oracle ODI Vs DataStage Balanced Optimization (Part 2)
rameshrr3

Replies: 9
Views: 3974

PostForum: Data Integration   Posted: Thu Apr 14, 2016 5:04 pm   Subject: Oracle ODI Vs DataStage Balanced Optimization (Part 2)
@Chulett : (Part 1) is on the same shelf where windows 9 and datastage 10 are Wink

Part1 is just what I consider previous debates on this topic , but did not want to hijack those older threads where ...
 Topic: IN clause in transformer
rameshrr3

Replies: 11
Views: 3567

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Apr 14, 2016 2:51 pm   Subject: IN clause in transformer
I would agree with Ray, the lookup functions ( Or Should i call them specifications Wink ) ) in modify stage have been used a couple of times by me in some projects, but the modify stage does not h ...
 Topic: Activation Lead Time
rameshrr3

Replies: 2
Views: 1019

PostForum: Site/Forum   Posted: Wed Apr 13, 2016 12:59 pm   Subject: Activation Lead Time
Ok, if its not activated after 48 hrs, will send an email to 'editor ' Smile
 Topic: IN clause in transformer
rameshrr3

Replies: 11
Views: 3567

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Apr 13, 2016 12:57 pm   Subject: IN clause in transformer
Despite its many strengths in customizability using C++, I still find the standard (prebuilt) DataStage parallel job function library to be hands down the worst (& worst documented) of any self r ...
 Topic: Activation Lead Time
rameshrr3

Replies: 2
Views: 1019

PostForum: Site/Forum   Posted: Wed Apr 13, 2016 12:46 pm   Subject: Activation Lead Time
I purchased premium membership a few minutes back , how long does it take to get activated ? I had quite a few issues last time and had to go to the extent of raising a paypal dispute.

Thanks
 Topic: Oracle ODI Vs DataStage Balanced Optimization (Part 2)
rameshrr3

Replies: 9
Views: 3974

PostForum: Data Integration   Posted: Wed Apr 13, 2016 11:52 am   Subject: Oracle ODI Vs DataStage Balanced Optimization (Part 2)
Thanks everyone, it will be a couple of days before I revive my 'premium' membership
On Q4

I'm of the opinion that Datastage/BalOpt already does this , IF the options are so selected, but ODI may ...
 Topic: Oracle ODI Vs DataStage Balanced Optimization (Part 2)
rameshrr3

Replies: 9
Views: 3974

PostForum: Data Integration   Posted: Tue Apr 12, 2016 6:35 pm   Subject: Oracle ODI Vs DataStage Balanced Optimization (Part 2)
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: The Debate revived
I'm at a site where we have two databases on Exadata. Although I have a DataStage bias, I would have to admit that ODI probably does a better job at pushing things down to Exadata where the processin ...
 Topic: Datastage Mainframe Edition GA!
rameshrr3

Replies: 11
Views: 902

PostForum: General   Posted: Wed Oct 07, 2015 1:34 pm   Subject: Datastage Mainframe Edition GA!
Thanks everyone. Our shop installed the Mainframe edition back in 2006 when they started off with V 7.0 or 7.51 A , and when we went to 8.7 we did not think twice to install or not install it, also ma ...
 Topic: Datastage Mainframe Edition GA!
rameshrr3

Replies: 11
Views: 902

PostForum: General   Posted: Wed Sep 30, 2015 12:14 pm   Subject: Datastage Mainframe Edition GA!
DataStage® Release: 11x
Job Type: 390
OS: Unix
Additional info: Is it still available after V 8.7
Our client is a big Mainframe shop with 5-10 physical mainframes and many many LPARS . Our datastage intsllation V 8.7 Fix pack 2 has Mainframe jobs enabled. Given that support for 8.7 will expire bet ...
 

 Jump to:   



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