29.12.2019
Posted by 
Parameters

Parameter File Worklet

In this blog I am going to explain how to generate parameter files dynamically using a CSV file as input and a parameter file as output. We’ll also look at how to update the parameter values in the parameter file for a particular session or workflow.Step 1:Let’s start with generating the parameter file. Here we use CSV as input and store the required information, such as folder names, workflows, worklets, sessions, parameter names, parameter values and number of parameters. Here is a sample CSV file we used to generate the parameter file:Step 2:Now import the source, target files and create a mapping.Source: CSV FileTarget: Parameter FileTarget file is delimited. Click “advanced” button to remove double quotes.Select “None” in Optional Quotes.Based on the number of parameters, we create multiple flows using router transformation.In the below image we created two groups:1. For workflow with a single parameter.2.

For workflow with two parameters.In the parameter file, basically there will be two sections: Header and Parameters. In the expression transformation we have extra ports (number of parameter +1 extra ports). For example, in the below image we have three ports: one for Header and two for parameters.Code for generating header part. This creates dynamic header based on values provided in CSV file.Code for parameter 1.Code for parameter 2.Normalizer transformation will convert columns to rows.If we have one parameter for a workflow then occurrence will be 2 (n+1).Here we have two parameters so we used 3 occurrences.By using Union transformation the records are merged.Step 3:Once we execute workflow, the parameter file is generated.Now updating the Parameter File for one workflow or session:1.Update CSV file and Generate Parameter FileAs we are using Flat files to store the information, update may not be simple.

Global Parameters In Informatica Parameter File Download

So, we generate a new file with the latest values and replace with existing file. For example, we have CSV1.csv file then we generate CSV2.csv with latest values (for that wf/session) and later we remove CSV1.csv and rename CSV2.csv to CSV1.csv.Source: CSV1.csvTarget: CSV2.csvIn the expression editor add a new port and use below code to update only for particular workflow.After running the workflow it generates CSV2.csv file. In the workflow add command task and use below code to move and replace CSV file.Command 1: move D:Informatica9.0.1serverinfasharedTgtFilesCSV2.csv D:Informatica9.0.1serverinfasharedSrcFilesCommand 2: del D:Informatica9.0.1serverinfasharedSrcFilesCSV1.csvCommand 3: rename D:Informatica9.0.1serverinfasharedSrcFilesCSV2.csv CSV1.csvAfter updating csv file, run the parameter workflow with CSV1.csv as input which generates parameter file with updated values.

Informatica Parameter File Format

Attention, Internet Explorer UserAnnouncement: Jive has discontinued support for Internet Explorer 7 and below.In order to provide the best platform for continued innovation, Jive no longer supports Internet Explorer 7.Jive will not function with this version of Internet Explorer. Please consider upgrading to a more recent version of Internet Explorer, or trying another browser such as Firefox, Safari, or Google Chrome.(Please remember to honor your company's IT policies before installing new software!).