Transaction Control Transformation in Informatica- Shikshaglobe

Content Creator: Vijay Kumar

What is Transaction Control Transformation?

Exchange Control is a functioning and associated change which permits us to commit or roll back exchanges during the execution of the planning. Commit and rollback tasks are vital as it ensures the accessibility of information.


While handling a high volume of information, there can be a circumstance when committing the information to the objective. On the off chance that a carry-out is performed too habitually, it will be an above to the framework. In the event that a commit is performed past the point of no return, on account of disappointment, there are chances of information misfortune.

So to give adaptability Transaction control change is given.

TCL COMMIT and ROLLBACK Commands

There are five in-fabricated factors accessible in this change to deal with the activity.


Model:

In this model, we will commit information to the objective when dept no =20 conditions is seen as evident

Stage 1 - Create a plan with EMP as source and EMP_TARGET as target

Exchange Control Transformation in Informatica with EXAMPLE


Stage 2 - Create another change utilizing the change menu, then, at that point,


Select an exchange control as the new change

Enter change name "tc_commit_dept20"

Select make choice

Exchange Control Transformation in Informatica with EXAMPLE

Stage 3 - The exchange control change will be made, select done fasten


Exchange Control Transformation in Informatica with EXAMPLE


Stage 4 - Drag and drop every one of the segments from the source qualifier to the exchange control change then, at that point, connect every one of the sections from the exchange control change to the objective table

Exchange Control Transformation in Informatica with EXAMPLE

Stage 5 - Double snap on the exchange control change and afterward in the alter property window

Select property tab

Click on the exchange control manager symbol

Exchange Control Transformation in Informatica with EXAMPLE

Stage 6 - in the articulation supervisor enter the articulation -

"iif(deptno=20,tc_commit_before,tc_continue_transaction)" and select OK


It implies on the off chance that deptno 20 is found, commit exchange in target, else the ongoing system.


Exchange Control Transformation in Informatica with EXAMPLE

Stage 7 - Select OK in the past window


Exchange Control Transformation in Informatica with EXAMPLE

Presently save the planning and execute it subsequent to making meetings and work processes. This planning will commit the information to the objective at whatever point office number 20 is tracked down in the information.

Tags:

transaction control transformation in informaticause of transaction control transformation in informaticalimitations of transaction control transformation in informaticatransaction control transformation in informatica cloudtransaction control transformation in informatica interview questionstransaction control transformation in informatica powercentertransaction control transformation to generate multiple files in informaticatransaction control transformation in informatica examplewhy transaction control transformation is active in informaticawhy do we use transaction control transformation in informaticawhat is transaction control transformation in informaticahow to use transaction control transformation in informaticatransaction control transformation in informatica bigquerytransaction control transformation in informatica batchtransaction control transformation in informatica b2ctransaction control transformation in informatica based ontransaction control transformation in informatica bdetransaction control transformation in informatica bdmtransaction control transformation in informatica bdm 10.1what is custom transformation in informaticatransaction control transformation in informatica developertransaction control transformation in informatica with exampletransaction control transformation flat file informaticatransaction control transformation in informatica guru99interview questions on transaction control transformation in informaticatransaction control transformation in informatica jobtransaction control transformation in informatica jdbctransaction control transformation in informatica javatransaction control transformation in informatica joinertransaction control transformation in informatica jobs in usatransaction control transformation in informatica kbtransaction control transformation in informatica knowledge basetransaction control transformation in informatica kpitransaction control transformation in informatica kafkatransaction control transformation in informatica networktransaction control transformation in informatica not workingtransaction control transformation in informatica nodetransaction control transformation in informatica netapptransaction control transformation in informatica newlookuprow valuestransaction control transformation in informatica repositorytransaction control transformation in informatica rdstransaction control transformation in informatica reporttransaction control transformation in informatica replicationtransaction control transformation in informatica repository querytransaction control transformation in informatica rows to columnstransaction control transformation in informatica remove duplicatestransaction control transformation in informatica scenariostransaction control transformation in informatica vitransaction control transformation in informatica vstransaction control transformation in informatica valuetransaction control transformation in informatica vimtransaction control transformation in informatica vs oracletransaction control transformation in informatica vs ssistransaction control transformation in informatica vs talendtransaction control transformation in informatica vs mulesofttransaction control transformation in informatica xmltransaction control transformation in informatica xpathtransaction control transformation in informatica xml filetransaction control transformation in informatica youtubetransaction control transformation in informatica youtube videotransaction control transformation in informatica youtube channeltransaction control transformation in informatica zapiertransaction control transformation in informatica zshtransaction control transformation in informatica zscalertransaction control transformation informaticatransaction control transformation in informatica 2022