Example for Post SQL: In a case that I have to delete the records for a particular day, once the entire ODS load finishes the stage records has to be deleted. In such cases I will write a post SQL to delete the stage records once it loads to ODS. Was this answer useful? Yes R...
What is DataStage? - A tool for designing Extraction, Transformation and Loading - An ideal tool for data integration projects system migrations - Importing, extracting and creating metadata are within these jobs - Data stage allows scheduling, monitoring and running the jobs - Allows to administer...