
In the future, he says, Scotiabank plans to leverage the reporting capabilities in the metadata browser to clarify the source of the data and the time at which the bank received it.

"We foresee a maintenance cost savings of between 30 and 40 percent."Īccording to McNamara, Informatica's PowerCenter has enabled Scotiabank to gain a unified view of its organization and respond rapidly to new business requirements and infrastructure changes. Previously, conversion took 48 hours, now it takes 24 hours," he says.
#Informatica metadata converter free download code
"We just did a conversion of a component of the code recently.

Features: Valuable features of Informatica PowerCenter include the metadata repository, the data warehouse application. Scotiabank is still completing the implementation, which began in December 2001 and is projected to take two more years to complete. SSIS users say the initial setup is easy. And population of the data warehouse is accelerated by PowerCenter's speed. The technical team can more quickly assess the impact of a potential change on the environment. Scotiabank's business staff can better identify which data to use for analysis. The bank has already seen productivity improve, asserts McNamara. Furthermore, PowerCenter's architecture fully utilizes metadata to deliver scalable performance, high re-use and up-to-date documentation of the integration process. "Metadata helps us catalog and track our data and treats the data as an asset," McNamara says. One of the features of PowerCenter that McNamara likes best is Informatica's metadata - data about data - which is the DNA of PowerCenter. The automated system segments customers based on contact history and marketing preferences, and it releases a file of customized sales leads within hours. Based on the success of the pilot, Scotiabank has developed statistical models to analyze transaction histories and determine individual behavioral patterns.

Scotiabank's pilot program ran from January 2002 to May 2002, utilizing PowerCenter as part of the bank's "Significant Deposit" marketing campaign, which allowed Scotiabank to identify and respond to changes in their customers' financial lives.
