DSXchange

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 result columns from the ref links to a subsequent transformer stage to do survivor scenario evaluation. ...

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 Websphere TX or even Java ( which had predefined IPS messaging containers for such industry standard for...

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

Only one group - since TEXT.OID is filtered on single value ? Whats the point - curious

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 :) On my canvas the Basic transformer now has the similar icon as parallel transformer , but the COLOR is different as i edited the bmp (PXSVtransformer.bmp ??) f...

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 impression the 2 went their own way after UV version 9.

@Chulett : (Part 1) is on the same shelf where windows 9 and datastage 10 are

Part1 is just what I consider previous debates on this topic , but did not want to hijack those older threads where I was not the OP.

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 have a lookup_string_from_string[] specification, its usually an int to to string or string to int ( t...

Ok, if its not activated after 48 hrs, will send an email to 'editor '

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 respecting ETL tool in the Gartner magic quadrant (as opposed to its BASIC transformer cousin). I see ...

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

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 majority of the developers who worked and managed datastage at the shop were from a Mainframe backgrou...

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 between 2017 and 2018, im wonderingif we still have support for mainframe jobs in Datastage Version 9.1...

and to remove g++ except for Linux. It currently lists g++ for various UNIX flavors but is not supported. This is misleading documentation, because the only time the compiler is invoked is when a (parallel) transformer or buildop stage are needed in the job design- which happens to be majority of t...

I have seen this performance degrade when my client moved from 7.51A ( Solaris) to 8.7.01 on AIX It also created a bunch of metadata issues ( Importing table defs etc ) We switched the ODBC SQL Server driver library to this one [NGDCAGLAPassport] Driver=/datastage/IBM/InformationServer/Server/brande...