QUERY IN SERVER JOBS

sunitha_cts · Post by **sunitha_cts** » Thu Jun 18, 2009 7:23 am

HI all,

I am coding jobs in server edition,i want to know clearly the concept of resuability ,because i should impement and show resuability in my jobs.i know that clearly we can do it by container and we have local and server shared container also ,i don't know how to implement ,can anyone guide me regarding this concept.

Secondly i have 2 flat files say read f1 and f2 ,read f1 names file and check if name stem (first 4 characters of name )is present in f2 names stem file.I f found update sequence number else add new name stem with sequence number increment sequence number or all records in f2 by 1. HOW CAN I IMPLEMEN THIS ?

KINDLY GIVE A SOLUTION
THANKS
SUNITHA

chulett · Post by **chulett** » Thu Jun 18, 2009 7:37 am

The convention here is one topic = one problem or question. Please don't string multiple unrelated questions into a single topic. Kindly give a new post for the flat file question. And please start doing a better job of chosing a more appropriate subject.

chulett · Post by **chulett** » Thu Jun 18, 2009 7:41 am

Containers are clearly documented in Chapter 5 of the Designer Guide pdf.

ray.wurlod · Post by **ray.wurlod** » Thu Jun 18, 2009 4:35 pm

Think also about Templates or prototype jobs, creating routines that are more general than specific (and perhaps Transforms to interface to them via more meaningful names. And the big one is table definitions - import them once, with column descriptions added, and only ever use Load to bring them into job designs.