All Stories

Change Capture Stage in Datastage

The change Capture stage in DataStage allows to Capture the Change in two source datasets(before and after) and mark the difference in one of the output column. The comparison is made by key columns specified in properties. The changes are…
Teradata connector Stage in Datastage

The Teradata Connector stage in DataStage allows to read and write records to the Teradata tables. The Teradata Connector stage has many capabilities and Better than earlier Teradata stages. Teradata API, Teradata Enterprise, Teradata Load and Teradata Multiload stages are depreciated,…
Remove duplicate Stage in Datastage : Quick Example

The Remove duplicate Stage in Datastage allows dropping duplicate records from the input data links.It can have one input and one output link. It also enable us to retain first or last record from the duplicates. Mandatory: The data source…
Unstructred Stage (Excel) in Datastage

The unstructured data stage in DataStage allows to read and write Excel files in DataStage. It was added in the latest version of DataStage. Earlier the Excel files were required to convert into CSV or delimited files but that not any…
Column generator Stage in Datastage

The Column Generator stage in DataStage is used to add extra columns with false data. It is a debug stage. It can be utilized while performing unit testing. Properties: Category/Property Values Options/Column Method Explicit/ Column Method Options/Column to Generate output…