Steps involving in implementation of ETL process

  1. Creating a Source definition.
  2. Creating a Target definition.
  3. Design a mapping with or without transformation rule.
  4. Create a session for each mapping.
  5. Create a wokflow.
  6. Finally start the workflow.
Note: In real-time environment, all the source tables and target tables are created by DBA. We just import the definition of the tables.

0 comments :

Post a Comment

> Related Posts with Thumbnails
 

Copyright © 2012. GS dot net - All Rights Reserved - Design by BTDesigner - Proudly powered by Blogger