All Stories

Copy stage in datastage

The copy stage in DataStage allows you to drop, rename or change the order of input columns. It could propagate records of input data set to any number of output links.This ability lets the developer perform backup and processing in…

There are three types of temporary tables in teradata . Global Volatile Derived Global temporary tables : The scope of global temporary tables limited to the session only . when session ends ¬†all the records¬†are dropped but the definition or…
Sequential file  Stage in datastage

The sequential file stage in DataStage allows to read and write the simple flat files. The flat files could be CSV or delimited by any particular character.Fixed width files are also supported by Sequential file stage. The stage has single…