about job design

dsdv78 · Post by **dsdv78** » Fri Jan 25, 2008 5:50 am

Hi All,

I have one about job design... My job design is as follows.

Database1
|
Dataset__>Transformer__>Lookup__>Database2
| |
S.File1 S.File2

In Transformer i handling the error records these are stored in S.File1and Datbase1 used as lookup purpose... Database2 used as target pupose.
S.File2 as used for error records...My doubt regarding to in S.file2 load is as inactive and also in lookup stage is also contain error. After remove the S.File2 the job is running very well.. I want get the error records in S.file2 also..How to design that job..Any one can help

Thanks

Raghavendra · Post by **Raghavendra** » Fri Jan 25, 2008 6:18 am

Please put your code design in code tags.

ray.wurlod · Post by **ray.wurlod** » Sat Jan 26, 2008 12:45 am

Yes, please do. Your job design without them is gobbledegook, as you can see.

dsdv78 · Post by **dsdv78** » Mon Jan 28, 2008 5:38 am

Hi,

I solved my problem

ray.wurlod wrote:Yes, please do. Your job design without them is gobbledegook, as you can see. ...

ray.wurlod · Post by **ray.wurlod** » Mon Jan 28, 2008 9:54 pm

Normal courtesy dictates that you post a message indicating HOW you solved your problem, so that future searchers can know.