satyaneerumalla

 Profile Answers by satyaneerumalla Questions by satyaneerumalla

• Sep 19th, 2006

 

  Mapping Specification

It is a metadata document of a mapping.

A typical Mapping specification contains:

1.Mapping Name

2.Business Requirement Information

3.Source System 
  
Initial Rows   
Short Description 
Refresh Frequency  
Preprocessing 
Post Processing 
Error Strategy 
Reload Strategy 
Unique Source Fields 

4.Target System

Rows/Load

5.Sources

Tables

Table Name Schema/Owner Selection/Filter
  
  
Files

File Name File Owner Unique Key

6.Targets

Information about different targets. Some thing like above one.

7.Information about lookups

8.Source To Target Field Matrix

Target Table Target Column Data-type Source Table Source Column Data-type 

Expression Default Value if Null Data Issues/Quality/Comments

  
Coming to Versioning of objects in repository...

In this we have to things

1.Checkout: when some user is modifying an object(source,target,mapping) , he can checkout it. That is he can lock it. So that until he release no body can access it.

2.Checkin:
When you want to commit an object u use this checkin feature.

  

Guest

• Sep 19th, 2006

 

  Mapping Specification

It is a metadata document of a mapping.

A typical Mapping specification contains:

1.Mapping Name

2.Business Requirement Information

3.Source System 
  
Initial Rows   
Short Description 
Refresh Frequency  
Preprocessing 
Post Processing 
Error Strategy 
Reload Strategy 
Unique Source Fields 

4.Target System

Rows/Load

5.Sources

Tables

Table Name Schema/Owner Selection/Filter
  
  
Files

File Name File Owner Unique Key

6.Targets

Information about different targets. Some thing like above one.

7.Information about lookups

8.Source To Target Field Matrix

Target Table Target Column Data-type Source Table Source Column Data-type 

Expression Default Value if Null Data Issues/Quality/Comments

  
Coming to Versioning of objects in repository...

In this we have to things

1.Checkout: when some user is modifying an object(source,target,mapping) , he can checkout it. That is he can lock it. So that until he release no body can access it.

2.Checkin:
When you want to commit an object u use this checkin feature.

  

sperumandla

 Profile Answers by sperumandla 

• Sep 21st, 2006

 

Please let me know the answer for this question.

calltomadhu

 Profile Answers by calltomadhu 

• Sep 22nd, 2006

 

hi

mapping is nothing but flow or work. where the data is coming and where data is going. for this we need

mapping name

source table

target table

session.

thanks

madhu