Transaction control transformation in Informatica explained with scenarios

The video explains Transaction control transformation in Informatica with real project scenario.
The Dept heads of all departments wants to see all the Policies sold by the employees working in their respective department on a monthly basis.
#TransactionControl #informatica #Techcoach
Using transaction control transformation the process will be automated and the files will be created department wise, So that only the Authorised individuals can see their department files

[@lingzou9696]

This vedio helps a lot, saved my time. thank you for your sharing👍👍👍👍

[@TechCoach]

Thanks buddy, I am glad I could help :)

[@srinivasvemula2331]

Hi bro ,its a great way of explaining the transformation. Now i got to know how much it is useful.Thank you.

[@carlosfabregas3578]

Excellent

[@TechCoach]

I am glad I could help :)

[@carlosfabregas3578]

@@TechCoach Now I have a problem, when I use this control and I need the generated files not to be in a specific directory but rather I have to host them via ftp to a specific server, it doesn't work for me, I get this error: "FileName Port is not supported with connection or merge option", any ideas?

[@TechCoach]

@@carlosfabregas3578 usually files are created using informatica and sent using SFTP in a shell script.

[@sumathik8154]

Hi Vivek , really this video is helped me a lot . Your way of explaining is really good ,thank you

[@TechCoach]

Thanks a lot buddy, please consider subscribing to my other channel as well it will really help me kzbin.info/www/bejne/bHiUqXqfYqlopdk

[@jhakaushal9510]

Thank you man!! Now i see where we can use this transformation! :)

[@TechCoach]

Thanks Kaushal, I am glad I could help

[@gotamkartik21]

most useful video before the interview. Thanks Much :)

[@TechCoach]

Thanks Karthik I am glad I could help.

[@user-eu3ev3um4p]

Good one. sir, does after processing all records at each transformation then forward the records to next transformation? or it it bunch wise or sequentially moved to next level transformation?

[@TechCoach]

You try running in debug mode for better understanding and it depends on the transformation ( like aggregateor, sorter would use bunch) for rest it would be row by row

[@akashpodder5502]

Excellent explanation!

[@TechCoach]

Thanks a lot buddy for the kind words :)

[@mkr7345]

Awesome

[@govindadhikari1]

great work Vivek. really appreciate ur work.

[@AnIndianAbroadd]

Thanks a lot for the kind words, I have a small request I am working on this new youtube channel " An Indian Abroad " and will really appreciate if you watch and subscribe to it. kzbin.info/www/bejne/Z2KnfGClrrekopI

[@AnIndianAbroadd]

Thanks a lot for the kind words, I have a small request I am working on this new youtube channel " An Indian Abroad " and will really appreciate if you watch and subscribe to it. kzbin.info/www/bejne/Z2KnfGClrrekopI

[@devmeher]

Thank you so much...Very informative video...I was actually looking for an scenario ..where my source record are not fixed and I want to populate only 1000 records into 1 flatfile and next set of 1000 records should write to another flatfile and the no of source record will keep changing everyday.Hope I can achive this my using transaction control .

[@TechCoach]

You can my using mod by 1000 and transaction control

[@fashion22102008]

Hi Vivek, Great way of explaining things!!!! I want to ask 2 things here...1. In output files records were repeated for single employee_id. Is it because each time workflow ran then records got appended or is there is any other reason for this? 2. Can we have only flat files as target for Transaction control transformation or can we have a scenario where relational target is also possible? Thanks in advance.

[@TechCoach]

Aditya the way I mocked up my source data allowed me to have multiple rows for a single employee since he can make multiple sales and the records were not appended. Regarding the 2nd question atleast I haven't came across a scenario where I used TC for relational target, If I had predefined possibilities I would rather use router transformation. I hope this helps.

[@fashion22102008]

Got it vivek. Thanks for explanation!!!

[@nanyabusiness401]

Very helpful

[@TechCoach]

Thanks a lot prachi for the kind words

[@shraddhadeshmukh6499]

Great videos Vivek.. could you please make detail videos on Informatica for beginners please.???

[@TechCoach]

Sure Shraddha, I already have some videos in place which may interest you.

[@tubevdos2043]

great vdo

[@mkr7345]

Good one

[@TechCoach]

Thanks a lot for the kind words buddy :)

[@mkr7345]

Why their is a file exptrans1.out in the directory of files generated .

[@ankushgondane8642]

Hi Vivek, please upload video for difference between static and dynamic catche and how both works. What drawbacks of static ctache so that we are going for dynamic catche in real time?

[@TechCoach]

+Ankush Gondane Sure Ankush I will try to make one on the same.

[@maryam4071]

thanks for the video. How can we have access to the resources?

[@TechCoach]

Thanks Maryam, which resources are you looking for exactly??

[@prasadmhatre9819]

Where are the basic tutorial you have made for informatics?

[@singhraunak09]

Does TC data can be store in db table

[@TechCoach]

@ Raunak, If you have well defined list of values for which files are to be generated do you think using router will make more sense?

[@singhraunak09]

@@TechCoach yes .. ur correct

[@TechCoach]

Perfect Raunak, I have a small request to you. I am working on this new channel please do watch and subscribe to it. Your support is my motivation. kzbin.info/www/bejne/hauXhZWHrNelhbs