Teradata Date Handling with Sample Queries

Teradata Date Handling: For Developer, handling the date is a very tedious task. the date format must be checked before inserting the date in the table. there are many ways to handle it. Sample table: CREATE VOLATILE TABLE SAMPLE_DATE, NO…
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…