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
How you Implemented SCD Type 1 & Type 2 in your project?
How do y read Sequential file from job control?
What are some prerequisites for datastage?
What are the various kinds of containers available in datastage?
How to perform incremental load in datastage?
what is the custome stage in datastage? how can we impliment that one? plz tell me
CHANGE CAPTURE
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
What are the main differences you have observed between 7.x and 8.x version of datastage?
Define data aggregation?
What is a merge in datastage?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
How do you generate sequence number in datastage?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
Whats difference betweeen operational data stage (ods) and data warehouse?