Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

Jump to content

Database caching in BW


Recommended Posts

  • 4 years later...

Soumitra,

caching depends upon how much data you need to cache.

if your table is too large then its better to use JDBC queries rather than thrashing the BW engine by keeping it in cache.

In case you need to cache few thousand data from table then better you can use something like static Hashtable (using java activities) and retrieve the same using the key/value pairs.

 

Thanks

Ramesh S

Link to comment
Share on other sites

  • 3 years later...
  • 11 months later...
  • 2 weeks later...
×
×
  • Create New...