Hudson's Bay Company is Canada's oldest retailer -- more than 307 years old. Binaifer and Irina's session is a case study of their meta data program.
They use CA ERwin for preparing data models. Teradata SQL is used to do downstream views impacted. They use Informatica MetaManager for administering their meta data program.
Some of the prepackaged reports they offer:
- Re-usability analysis of objects
- Data Integration operation and administration
- Metamodel exploration (class inheritance, class attributes)
- Mapping of dependencies from source to target
They also map their meta data to an industry standard XML schema, the ARTS XML (IX Retail) schemas in MetaManager.
In the future they hope to build a more business friendly view of their meta data tools, as they feel that currently their tools are not usable to a wider business audience.
__________________________________________________
Role of Metadata Management within the Integration Framework at Hudson's Bay Company
Binaifer R Karanjia
Data Architect
HBC
Irina Kleiner
Senior Data Analyst
HBC
Wednesday, March 19, 2008
11:15 AM - 12:15 PM
Level:
Intermediate
HBC is currently setting up an Integration Center of Excellence using the SOA Framework and Metadata Management is at the core around which all the other services are planned to be structured. The presentation will show the work we have already done in implementing an Integration Metadata Management Framework within the Organization and how we plan to use this Metadata. The key areas for which HBC envisages to use Metadata Management are: 1. Interface Inventory 2. Understand the Lineage 3. Impact Analysis and Change Management Process 4. Linking the Business and Technical Metadata. The presentation will seek to enable the audience to appreciate the point of arrival for HBC in this journey, where we are and the process we have followed to reach this stage in our journey and the road ahead of us.
Binaifer is working as a Metadata Architect with Hudson's Bay Company(HBC) with the Integration Center of Excellence (ICE) Group. She is responsible for setting up the Metadata Center of Excellence within HBC. Prior to this Binaifer has worked extensively in the field of Data Warehousing with organizations such as IBM Business Consulting Services and NCR Teradata specifically in the area of Data Modeling. She has done her Bachelors in Engineering followed by a Masters in Management.
Irina is working as a Senior Data Analyst in Hudson's Bay Company(HBC) with the Integration Center of Excellence (ICE) Group.
She is a part of the team for setting up the Metadata Center of Excellence within HBC. Prior to this Irina has worked extensively in the field of Data Management with organizations such as Sun Life Trust & Securities, Ministry of Public Health (USSR) specifically in BI. She has done her Bachelor in Information Technology & Masters in Science.