May 9, 2013 \ Ananth TM \ 1 Comment Stages in Datastage There are different types of Stages in Datastage. 1)Database Stages 2)File Stages 3)Development Stages 4)Processing Stages 5)Real Time Stages In Database Stages, mostly used stages are a)Oracle Enterprise b)ODBC Enterprise c)ODBC Conductor d)DB2 Enterprise e)Teradata Enterprise f)Informic g)Dynamic RDBMS h)Universe i)MS SQL Server Load And in Processing Stages mostly used stages are a)Aggregator Stage b)Command Stage c)Pivot Stage d)Transformer Stage e)Sort Stage f)Merge Stage g)Link Partitioner Stage h)Join Stage i)Lookup Stage j)Copy Stage k)Funnel Stage l)Surrogate Key M)SCD N)Filter StageThe file stages are as followsa)Sequential Stage b)Data Set Stagec)File Set Staged)Lookup file set stagee)Complex Flat File Stagef)External Source StageThe Development Stages area)Row Generatorb)Column Generator c)Head Staged)Tail Stagee)Sample Stagef)Peek Stage