Number of datasets which we can use in a single project
Posted: Mon Dec 07, 2009 1:20 am
Hi,
Actually there is a issue occured in our project...We want to store the cleanse data into intermedate stage..same as staging table ...initially we were extracting the data from the source and directly loading it into the target tables...but now we have to store the data into some intermediate stage( that is datasets) ....ideally the best option would be to store it into staging tables...but since there is lack of time....we decide to store the data into datasets....So is there any limit to use datasets, how many datasets which we can use in a particular project...is there any way to find out the free size in a particular project ??
The data volume is pretty huge and number of datasets which we are going to create will also be very huge...![Smile :)](./images/smilies/icon_smile.gif)
If we use may datasets....it won't effect performance of other proejects on same datastage servers...
I don't know if its really very foolish questions...but gurus ...please shade some light on the same....
Thanks in Advance!!
Actually there is a issue occured in our project...We want to store the cleanse data into intermedate stage..same as staging table ...initially we were extracting the data from the source and directly loading it into the target tables...but now we have to store the data into some intermediate stage( that is datasets) ....ideally the best option would be to store it into staging tables...but since there is lack of time....we decide to store the data into datasets....So is there any limit to use datasets, how many datasets which we can use in a particular project...is there any way to find out the free size in a particular project ??
The data volume is pretty huge and number of datasets which we are going to create will also be very huge...
![Smile :)](./images/smilies/icon_smile.gif)
If we use may datasets....it won't effect performance of other proejects on same datastage servers...
![Confused :?](./images/smilies/icon_confused.gif)
![Razz :P](./images/smilies/icon_razz.gif)
Thanks in Advance!!