informatica powercenter - Parameterise Parm File name In Informatatica -


i want know how (or can i) parameterize parm file name in informatica?

little bit of background. building standard map in informatica. business users can call directly after selecting standard filters want apply in map using gui.

the parm file name given business users , filters he/she selected in parm. file dropped in parm folder in informatica server.

this case scenario, when 1 users using @ 1 point of time.

also, want find out should when multiple users working on gui , generating parm files , invoking informatica map. how multiple instences of same map running @ same time?

i hope making sense here....

thanks!!!

you can achieve using concurrent execution of workflow. read , understand how can implement it.

once know how implement it, use backend script/code gui assign instance name each call through gui. each instance name, can have individual parameter file. (i believe there finite set of combination of variable values in case). can use below command call individual instances, (either through gui or other backend code.

pmcmd %workflow_name% %informatica_folder_name%   -paramfile %paramfilepathandname% -rin %instance_name% 

it might sound bit confusing, once understand how concurrent workflows work, can build on based on above input.


Comments