What is difference between 8.1 , 8.5 and 9.1 ?

Answer Posted / pavan

1. Balance Optimization :
DS8.5: Balanced Optimization is that to redesign the job automatically with maximize performance by minimizing the amount of input and output performed, and by balancing the processing against source, intermediate, and target environments. The Balanced Optimization enables to take advantage of the power of the databases without becoming an expert in native SQL.
DS8.7: No Change
DS9.1: Balanced Optimization for Hadoop.








2. Transformer Enhancements
DS8.5: Looping in the transformer, Multiple output rows to be produced from a single input row. 1. New input cache: SaveInputRecord(), GetSavedInputRecord().
         2. New System Variables: @ITERATION, @Loop Count, @EOD(End of data flag for last row).
         3. Functions : LastRowInGroup(InputColumn).
         4. Null Handling more Options.
DS8.7: No Change
DS9.1: New Transformation Expressions has been added. EREPLACE :  Function to replace substring in expression with another substring. If not specified occurrence, then each occurrence of substring will be replaced.








3. Big Data File Stage :
DS8.5: Not Exist
DS8.7: Big Data File Stage for Big Data sources (Hadoop Distributed File System-HDFS).
DS9.1: New Enhancement on
1. The IBM Big Data Solution Integrate and manage the full variety, velocity and volume of data.
2. New Hadoop-based Big Data Support Any to Big Data.
3. Big Data Integration with DataStage.




4. Added Java Integration Stage
DS8.5: Not Exist
DS8.7: Not Exist
DS9.1: Java code and creates baseline for upcoming big data source support.


5. Added Unstructured text stage
DS8.5: Not Exist
DS8.7: Not Exist
DS9.1: Excel read capabilities on all platforms with rich features to support ranges, multiple worksheets and New Unstructured data read

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

960


explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

1934


What is the project in datastage?

671


If you want to use a same piece of code in different jobs, how will you achieve this?

800


Explain the datastage parallel extender (px) or enterprise edition (ee)?

743






how many rows sorted in sort stage by default in server jobs

3564


Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

1671


Define project in datastage?

669


8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

1786


Describe routines in datastage? Enlist various types of routines.

585


How to read the length of word in unix?

888


What are routines in datastage?

778


What are the enhancements made in datastage 7.5 compare with 7.0?

713


Does datastage support slowly changing dimensions ?

663


how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

2738