New features and changes in InfoSphere Information Server Version 11.7

Latest information: Governance updates Data Quality updates Integration updates Administration and management updates Deprecated features Governance updatesInformation Governance Catalog New InfoSphere Information Governance Catalog Information Server Enterprise Search Information Server Governance Monitor Information Governance Catalog New New in 11.7 This version of Information Governance Catalog has a new user interface which improves user experience. You can search for assets in your entire enterprise by using enhanced search that takes...

How do I make the Oracle EE Stage Read Operator Run in Parallel?

By default the oraread operator is set to run in sequential mode. To enable parallel mode on oraread , you have to add the partition table property. This is set in the Source properties section. Then you specify the table name of this property. If more than one table is being used in the select statement, then specify only one of the tables used. You can then specify a Partitioning Algorithm to use when partitioning the table across nodes. It is recommend that you add the environment APT_ORAREAD_PARALLEL_ALGORITHM to the job and set its value...

DataStage Scenario on Finding Unique Distance from Source and Destination

Source,Destination,Distance hyd,bang,1000 delhi,chennai,1500 chennai,bang,600 bang,hyd,1000 bombay,pune,1000 bang,chennai,600 **Sorted on Distance** Source,Destination,Distance bang,chennai,600 chennai,bang,600 bang,hyd,1000 bombay,pune,1000 hyd,bang,1000 delhi,chennai,1500 **Stg Variables** PrevActualStr: ActualStr ActualStr: inp.Src:inp.Dest RevStr: inp.Dest:inp.Src isDup: if PrevActualStr = RevStr then 1 else 0 **Constraint** isDup = 0 [Constraint] The below steps will explain you, How the records will be processed to o/p based on the above...

Performance Optimization technique to handle variable length data in Data Set

...