Extracting data from one system and loading in to a local data mart / data store, especially when there are hundreds of tables will definitely take time to develop & execute. How do you cut down the development time and load data more quickly?
Read this blog from Lucid Technologies and Solutions to understand how to use the Runtime Column Propagation (RCP) feature in DataStage to quickly load hundreds of tables of data to your local data mart or data store: http://bit.ly/1sTDK8K