What is the Difference Between DataStage 7.5 version and 8.1
Version?

Answer Posted / swetha

In 7.5we have designer,director,manager,admin but in 8.0.1
manager includedd in designer.added some new stages range
lookup and scd stage.
connection objects are new objects that hold connection
information user name and password,database name to a
particular source or target which allows saving and reusing
connection information.
surrogate key generator stage whre will generate the
surrogate keysacrosss job execution runs.A new surrogate
key generator stage support following sources to generate
the sequence numbers(I)DB Sequence(II)File.
new connectors are invented the new connetors are easier to
use and extent functionality from existing connectors.

Is This Answer Correct ?    20 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the steps required to kill the job in Datastage?

686


What are routines in datastage? Enlist various types of routines.

627


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

3556


Can you highlight the main features of ibm infosphere information server?

635


How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

1699






Differentiate between Join, Merge and Lookup stage?

647


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.

3503


How and where you used hash file?

659


If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

1629


How do you import and export data into datastage?

701


Name the third party tools that can be used in datastage?

616


Explain connectivity between datastage with datasources?

599


What is the difference between Datastage 7.5 and 7.0?

673


Explain Quality stage?

671


How to manage date conversion in Datastage?

640