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
how to run a sequential file stage in parallel if the stage is used on the TARGET side
which r the connectors used in san?
What is the purpose of pivot stage?
Describe routines in datastage? Enlist various types of routines.
Define repository tables in datastage?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
Explain the importance of surrogate key in data warehousing?
What are sequencers?
Define Merge?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
What is ibm datastage?
how to export or import the jobs in .ISX file
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.