Page 1 of 1

about job design

Posted: Fri Jan 25, 2008 5:50 am
by dsdv78
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

Posted: Fri Jan 25, 2008 6:18 am
by Raghavendra
Please put your code design in code tags.

Posted: Sat Jan 26, 2008 12:45 am
by ray.wurlod
Yes, please do. Your job design without them is gobbledegook, as you can see.

Posted: Mon Jan 28, 2008 5:38 am
by dsdv78
Hi,

I solved my problem


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

Posted: Mon Jan 28, 2008 9:54 pm
by ray.wurlod
Normal courtesy dictates that you post a message indicating HOW you solved your problem, so that future searchers can know.