Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between 8.1 , 8.5 and 9.1 ?
- 1 Answers
- 16238 Views
- IBM, I also Faced
- E-Mail Answers
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
Is the value of staging variable stored temporarily or permanently?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
What is "fatal error/rdbms code 3996" error?
What is the command line function to import and export the ds jobs?
Can you explain link buffering?
What are the areas of application?
What are the difference types of stages?
What is the difference between Datastage 7.5 and 7.0?
What are the main differences you have observed between 7.x and 8.x version of datastage?
How to perform incremental load in datastage?
How do you run datastage job from the command line?
Difference between data warehousing and olap?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
What is a datastage job?
What are the benefits of datastage?
