DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
somu_june



Group memberships:
Premium Members

Joined: 14 Sep 2005
Posts: 439
Location: 36p,reading road
Points: 5112

Post Posted: Tue Oct 11, 2005 10:22 am Reply with quote    Back to top    

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

_________________
somaraju
kcbland

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 15 Jan 2003
Posts: 5209
Location: Lutz, FL
Points: 39192

Post Posted: Tue Oct 11, 2005 10:50 am Reply with quote    Back to top    

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 li ...

_________________
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rate this response:  
Not yet rated
ramdev_srh
Participant



Joined: 24 Jul 2006
Posts: 16

Points: 87

Post Posted: Tue Jul 25, 2006 9:39 am Reply with quote    Back to top    

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
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54086
Location: Sydney, Australia
Points: 293338

Post Posted: Tue Jul 25, 2006 2:50 pm Reply with quote    Back to top    

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!

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours