DataSet Vs Database
Posted: Fri Jul 21, 2006 7:54 am
I would like to know which one is the best practice in below scienario
sourceDataSet/Database ----> transfromation --> lookups ---> Database
i have several lookups it includes tables, some of the tables act like 2 times with different query on the table. entire job includes 10-12 lookups
which is the best way whether to use database or Dataset in lookups for the best performance
suppose if the Jobs started all stage will active at same time and closes at same time. how it will work?
Thanks in Advance
Samba
sourceDataSet/Database ----> transfromation --> lookups ---> Database
i have several lookups it includes tables, some of the tables act like 2 times with different query on the table. entire job includes 10-12 lookups
which is the best way whether to use database or Dataset in lookups for the best performance
suppose if the Jobs started all stage will active at same time and closes at same time. how it will work?
Thanks in Advance
Samba