RE: What is the diffrence between IBM Web Sphere DataStage 7.5 (Enterprise Edition ) & Standard Ascential DataStage 7.5 Version ?
IBM Information Server also known as DS 8 has more features like Quality Stage & MetaStage . It maintains its repsository in DB2 unlike files in 7.5. Also it has stage specifically for SCD 1 & 2.
RE: What is the diffrence between IBM Web Sphere DataStage 7.5 (Enterprise Edition ) & Standard Ascential DataStage 7.5 Version ?
I think there is no version like standard Ascential DataStage 7.5, I know only the advanced edition of Datastage i.e., only web sphere Datastage and Quality stage, it is released by IBM itself and given the version as 8.0.1, in this there are only 3 client tools(admin..,desig..,director), here they have removed the manager, it is included in designer itself (for importing and exporting) and in this they have added some extra stages like SCD stage , by using this we can impliment scd1 and scd2 directly, and there are some advanced stages are there.
They have included the QualityStage, which is used for data validation which is very very importent for dwh. There are somany things are available in Qualitystage, we can think it as a seperate tools for dwh.