DSXchange

Hi,
Can any one tell me how to craete a before job subroutine using basic functions for data cleansing. I need subroutine code for data cleansing.







Thanks,
Somaraju

Welcome aboard. Please post your questions in the relevant forums, the FAQ is not the right place for your question.

Please describe what you mean by data cleansing. Are you talking about an library of data quality information that is used by a process to inspect, validate, and repair data discrepancies? Or do you need profiling information gathered?

somu_june wrote:Hi,
Can any one tell me how to craete a before job subroutine using basic functions for data cleansing. I need subroutine code for data cleansing.







Thanks,
Somaraju

Hi ,
In job properties window you can mention before subroutine and after subroutine.

Pls correct me if it is a mistake.

Regards
ramdev

somu_june wrote: Can any one tell me how to craete a before job subroutine using basic functions for data cleansing. I need subroutine code for data cleansing.

You create the routine as type "before/after subroutine" in the Routines branch, and refer to it in the job properties dialog in the before-job subroutine field.

Why do you want to write code to do data cleansing? Surely that is one of the purposes of DataStage itself!