Thursday, December 27, 2012

Stored Procedure Transformation

Explain about Stored Procedure Transformation

Stored Procedure transformation is a passive transformation which is used to import Stored Procedure from database
Stored Procedure should exist in the database before using the Stored Procedure in the mapping

Set the following properties to define Stored Procedure transformation

1. Normal: This the default property set for the Stored Procedure transformation, it allows you to pass record by record to mapping during session execution

2. Source preload: A stored procedure executes before session reads the data from the source

3. Source postloadA stored procedure executes after session reads the data from the source

4. Target preload : A stored procedure executes before session loads the data into the target

5Target postload : A stored procedure executes after session loads the data into the target

There are two types of stored procedures

1. Connected Stored procedure
2. Unconnected Stored procedure

27 comments:

  1. Informatica is one of the most trusted and effective ETL software which is known globally. Informatica is one data warehousing ETL tool. Informatica ha very go opportunities for job across the world. Informatica Training in Chennai | Informatica Course in Chennai

    ReplyDelete
  2. I got knowledge about this topic through your informative post.
    sas training in chennai/
    sas training in chennai

    ReplyDelete
  3. Thanks for sharing this informative content that guided me to know the details about the training offered in different technology.
    software training in chennai

    ReplyDelete
  4. Nice article Thanks for sharing this article Wonderful information from this website Thanks !!!

    Embedded training in chennai | Embedded training centre in chennai | PLC Training institute in chennai

    ReplyDelete
  5. This comment has been removed by the author.

    ReplyDelete
  6. Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging.
    angularjs Training in chennai

    angularjs Training in bangalore

    angularjs-Training in tambaram

    angularjs-Training in sholinganallur

    angularjs-Training in velachery

    ReplyDelete
  7. It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me...
    python training in OMR
    python training in tambaram
    python training in annanagar

    ReplyDelete
  8. It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me...
    Selenium Training in Chennai | Selenium Training in Bangalore | Selenium Training in Pune | Selenium online Training

    ReplyDelete
  9. I’d like to write some material for your blog in exchange for a link back to mine. Please shoot me an email if interested. Thanks.
    industrial safetyu courses in chennai

    ReplyDelete
  10. Nice post. I learned some new information. Thanks for sharing.

    bloggydirectory
    Education

    ReplyDelete
  11. More informative,thanks for sharing with us.
    this blog makes the readers more enjoyable.keep add more info on your page.
    Aws Certification in Bangalore
    AWS Web Services Training in Bangalore
    AWS Training in Perambur
    AWS Training in Nungambakkam

    ReplyDelete
  12. It is a great post. Keep sharing such kind of useful information.

    Guest posting sites
    Education

    ReplyDelete

Related Posts Plugin for WordPress, Blogger...