DSXchange

DJhigh, You exactly grabbed what I stated. I plan of keeping my jobs not in too many compenents. So would you call it a bad practise and performance effective if a person is maaking lookups with 12 hash files , transforming it, again looking it up with another big no. of hsh and then aggregation and...

Hi Gurus, Is there is a performanc issue if I design all my jobs in one stage ie; i do all my loads from trg, then aggregations, transformationss,etc and load it to src. Or if I modularize the job and do it in different stages. To me Modularizing would gives an ease with toubleshooting. new learner.