How to dynamically create target files based on input conditions using Transaction Control ?

You need to generate multiple flat file using an Informatica mapping based on the source data content or some other business rule; from a single data source. For example-
Create separate target files and load employees in them department wise. You don't know the total number of departments.
#informaticinterview #transactioncontrol #informaticascenarios

[@JC_Magi]

Thanks

[@vamshidharv7]

Thank you so much !! It was really helpful.

[@soumyavusikarla413]

Hi, I have a scenario like there is one source flat file and target is 3 tables/flat files..so first time all the data should go to table1 and in 2nd run all the data should go to table 2 and in 3 Rd run all the data should go to table 3 and same process has to be repeated ..could you please help me with the solution

[@amitojsahni939]

Hi,I have tried this scenario but i can only see one out file in target file folder .Other 3 csv files are not getting generated dynamically. Can you please help me what could be the reason for that.

[@sowmyagayatrichelluboyina2561]

How to proceed if we have a situation like according to the number of input files the target files should be created?

[@viveksingh-oh8xi]

Hi, I have created the mapping as you explained in your videos but in my scenario only one csv file generated with admin department and all the records in it. could you please let me know what could be the reason..??

[@PranoyGuha]

Are you mapping the columns as mentioned in the video ? In the expression box, the FLAG field must lie between the CURR_VALUE and PREV_VALUE fields.

[@vidyasagar6924]

Hi, In the same way can we create tables in DB dynamically on the fly..?

[@anilkumarkokkula8730]

no

[@sreenadhchanti3741]

Hi,I have created the mapping as you explained and i got the output as expected. I have a doubt we got the output in csv format.is there is any possibility to create the output in tables.

[@anilkumarkokkula8730]

No

[@kavitha4384]

Thanks