This Blog is all about ETL related Information.It gives information about Datastage ,Informatica,Oracle,SQL,PL/SQL ,Unix,Data warehousing ,Data Modeling and ER Model concepts and FAQ's
Friday
New Stages in DataStage Version 8
New Stages in Datastage Version 8
A new stage from the IBM software family, new stages from new partners and the convergence of QualityStage functions into Datastage. Apart from the SCD stage these all come at an additional cost.
WebSphere Federation and Classic Federation
Netezza Enterprise Stage
SFTP Enterprise Stage
iWay Enterprise Stage
Slowly Changing Dimension: for type 1 and type 2 SCDs.
Six QualityStage stages
New Functions in Existing Stages
Complex Flat File Stage: Multi Format File (MFF) in addition to existing cobol file support.
Surrogate Key Generator: now maintains the key source via integrated state file or DBMS sequence.
Lookup Stage: range lookups by defining checking high and low range fields on the input or reference data table. Updatable in memory lookups.
Transformer Stage: new surrogate key functions Initialize() and GetNextKey().
Enterprise FTP Stage: now choose between ftp and sftp transfer.
Source :