Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Clarifying terminology: Source, Staging, Target, Mapping, Target Mapping?

612389Mar 12 2008 — edited Mar 14 2008

I'm new to ETL and I find the terminology in the literature to be confusing. I'm just trying to get a basic outline of the flow of data.

I can't acurately distinguish between the following terms that are used and the order that they come in the overall data mapping and deployment process:
1) Source table
2) Staging table
3) Target table
4) Mapping table
5) Target Mapping table

Are some of these terms interchangeable? Can a table share more than one of these terms? Any help would be appreciated.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 11 2008

Added on Mar 12 2008

#data-warehousing, #warehouse-builder

5 comments

1,343 views