Parameterize the Flat File Name & Directory in Informatica PowerCenter

How to Parameterize the Flat File Name & Directory in Informatica PowerCenter. Let’s walk through the steps by parameterizing the target file directory and the file name.

  • Define the workflow variables for Target file directory & file name
  • Assign the variable fields in the session task
  • Give the location of the parameter file in the workflow level (We are using workflow parameter file in this example)
  • Create a parameter file and define the actual values for parameter fields.

Edit the workflow, Go to variables and define the variables for Target file path and file name

Edit the session task (mapping), go to Targets file properties and assign the variables like below.

Give the parameter file name in the workflow like below. We are using workflow level parameter file in this example. You can also use the parameter file in session level.

Finally, create a parameter file and define the actual values for the workflow variables.

That’s all. When you run the workflow, the integration service assign the workflow variables from the parameter file and use it in the session level. The target file will be created in the location given in the parameter file.

Have any questions? or need help with this topic, please do reach out to me at kvtinformatica@gmail.com. Don’t forget to follow my Youtube channel and FB page, Lets stay connected and learn together.