Explain about Stored Procedure Transformation
Stored Procedure transformation is a passive transformation which is used to import Stored Procedure from database
A 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 postload: A 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
5. Target 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
Stored Procedure transformation is a passive transformation which is used to import Stored Procedure from database
A 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 postload: A 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
5. Target 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
Thanks for posting the useful information on
ReplyDeleteStored procedure transformation in informatica
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
ReplyDeleteI got knowledge about this topic through your informative post.
ReplyDeletesas training in chennai/
sas training in chennai
Thanks for sharing this informative content that guided me to know the details about the training offered in different technology.
ReplyDeletesoftware training in chennai
thanks for information...
ReplyDeletedot net training in chennai
Nice article Thanks for sharing this article Wonderful information from this website Thanks !!!
ReplyDeleteEmbedded training in chennai | Embedded training centre in chennai | PLC Training institute in chennai
Really very nice blog information for this one and more technical skills are improve,i like that kind of post.
ReplyDeleteDevops training in velachry
Devops training in OMR
Deops training in annanagar
Devops training in chennai
Devops training in marathahalli
Devops training in rajajinagar
Devops training in BTM Layout
Really very nice blog information for this one and more technical skills are improve,i like that kind of post.
ReplyDeletejava training in omr
java training in annanagar | java training in chennai
java training in marathahalli | java training in btm layout
java training in rajaji nagar | java training in jayanagar
This comment has been removed by the author.
ReplyDeleteGood 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.
ReplyDeleteangularjs Training in chennai
angularjs Training in bangalore
angularjs-Training in tambaram
angularjs-Training in sholinganallur
angularjs-Training in velachery
Greetings. I know this is somewhat off-topic, but I was wondering if you knew where I could get a captcha plugin for my comment form? I’m using the same blog platform like yours, and I’m having difficulty finding one? Thanks a lot.
ReplyDeleteAmazon Web Services Training in Tambaram, Chennai|Best AWS Training in Tambaram, Chennai
Amazon Online Training
AWS Training in JayaNagar | Amazon Web Services Training in jayaNagar
AWS Training in Rajaji Nagar | Amazon Web Services Training in Rajaji Nagar
Amazon Web Services Training in Pune | Best AWS Training in Pune
AWS Online Training | Online AWS Certification Course - Gangboard
It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me...
ReplyDeletepython training in OMR
python training in tambaram
python training in annanagar
It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me...
ReplyDeleteSelenium Training in Chennai | Selenium Training in Bangalore | Selenium Training in Pune | Selenium online Training
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.
ReplyDeleteindustrial safetyu courses in chennai
Excellent content thanks for sharing the unique information and keep posting.
ReplyDeleteInformatica Training
Oracle DBA Training
Oracle PLSQL Training
Oracle Performance Tunning Training
Thanks for taking time to share this valuable information admin. Really informative, keep sharing like this.
ReplyDeleteAngularjs Training Chennai
Angularjs courses in Chennai
Angular Training in Chennai
Best Angularjs Training in Chennai
AWS Training in Chennai
DevOps Training in Chennai
I believe that your blog will surely help the readers who are really in need of this vital piece of information. Waiting for your updates.
ReplyDeleteSpoken English Classes in T Nagar
Spoken English Classes in Vadapalani
Spoken English Classes in Chennai Nungambakkam
Spoken English Training near me
Spoken English Classes in Anna Nagar
Spoken English Classes in Perambur
Spoken English Classes in Ayanavaram
This is really too useful and have more ideas and keep sharing many techniques. Eagerly waiting for your new blog keep doing more.
ReplyDeleteAws Coaching Centre in Bangalore
cloud computing training institutes in bangalore
best cloud computing training in bangalore
cloud computing certification in bangalore
Aws Certification Training in Bangalore
Nice post. I learned some new information. Thanks for sharing.
ReplyDeletebloggydirectory
Education
More informative,thanks for sharing with us.
ReplyDeletethis 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
Thanks for sharing this valuable information. Keep up the good work and share more like this.
ReplyDeleteccna Training in Chennai
ccna Training near me
ccna course in Chennai
ccna Training institute in Chennai
ccna institute in Chennai
ccna Training center in Chennai
Really great information. Thanks for sharing.
ReplyDeleteTally Course in Chennai | Tally Classes in Chennai | Tally Training in Chennai | Tally Course | Learn Tally | Tally Institute in Chennai | Learn Tally ERP 9 | Tally Training | Tally Training Institute in Chennai
ReplyDeleteYour post is great. It shows your deep understanding of the subject. Waiting for your future posts.
Pega training in chennai
Pega course in chennai
Pega training institutes in chennai
Pega course
Pega training
SAS Training in Chennai
SAS Course in Chennai
IELTS Coaching in Chennai
IELTS Training in Chennai
Great post very impressive to read
ReplyDeleteCCNA training class in chennai
Amazing Post. The way of writing is very unique. Your write-up is extra-ordinary. Thanks for Sharing.
ReplyDeleteNode JS Training in Chennai
Node JS Course in Chennai
Node JS Training in Velachery
Node JS Training in Tambaram
Node JS Training in OMR
It is a great post. Keep sharing such kind of useful information.
ReplyDeleteGuest posting sites
Education
Very nice information, it is valuable and useful to so many people. It gives the beautiful knowledge especially to the technical people.
ReplyDeletecloud computing training institutes in bangalore
cloud computing training in bangalore
best cloud computing training institutes in bangalore
cloud computing training course content
cloud computing training interview questions
cloud computing training & placement in bangalore
cloud computing training center in bangalore