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 is the custome stage in datastage? how can we impliment that one? plz tell me

1911


What is the difference between operational data stage (ods) and data warehouse?

675


Differentiate between hash file and sequential file?

584


What is the use of datastage designer?

638


What are the primary usages of datastage tool?

623






What is data partitioning?

745


What is the sortmerge collector?

664


What is process model?

1551


how do u catch bad rows from OCI stage? And what CLI stands for?

2288


Differentiate between datastage and informatica?

727


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

1929


What are the different types of lookups in datastage?

630


What is the precedence of stage variables,derivations, and constraints?

600


What is the difference between validated and compiled in the datastage?

703


What is the difference between odbc and drs stage?

639