What is difference between 8.1 , 8.5 and 9.1 ?



What is difference between 8.1 , 8.5 and 9.1 ?..

Answer / 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

More Data Stage Interview Questions

How to read multiple files using a single datastage job if files have the same metadata?

0 Answers  


Define Job control?

0 Answers  


1)How to do error handling in datastage? 2)Did sequential stage accepts .xl files ,xml? znd how?

2 Answers   UHG,


What is the difference between validate and compile?

1 Answers   CTS,


Thanks to all people who are posting their comments...

1 Answers   CTS,






I have the following columns in the EMP table Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let us say the dob is 15th-Jan-1981) Desing a job such that the output contains the following empname,year(sal),tot(sal) and current age i.e. whether 18yrs or so on

1 Answers   Accenture,


how can u find out the datastage job is running on how many nodes

7 Answers   IBM,


How you Implemented SCD Type 1 & Type 2 in your project?

0 Answers  


Emp login_timestamp Logout_timestamp A,2019-02-01 02:24:15,2019-02-01 04:59:42 B,2019-03-29 14:43:30,2019-03-29 20:22:00 ABC,2019-03-29 12:43:00,2019-03-29 23:22:59 In the above calculate the duration of hours spent in office for each emp in datastage.

1 Answers  


how to handle null values using transformer stage?

1 Answers  


Hi Every one, I have a scenario plz suggest me 1)On daily we r getting some huge files data so all files metadata is same we have to load in to target table how we can load? 2) One column having 10 records at run time we have to send 5th and 6th record to target at run time how we can send? Hi plz help me for above scenarios and If any one is having JobSequence kindly send me one example and the scenario to my mail ID(nrvdwh@gmail.com)

3 Answers   HSBC,


WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

0 Answers  


Categories