Wednesday 5 March 2014

Using parameter file concept

Follow the shown steps to implement Parameter file concept in informatica.


Screen 1:

mapping view 


 Screen 2:

You can see the option in mappings tab called parameters and variables 


Screen 3:

create the parameter with $$parametername



Screen 4:

five the condition like this in filter transformation expression window we have the variable tab there you created parameter will be presented,

using that parameter we can write the expression here.



Screen 5:

the parameter should create in .prm format in specific path
like this



Screen 6:

copy that path and specify in work flow level



Screen 7:

From parameter connection is establishing that's why we are creating the connection variable for source.



Screen 8:

For Target also.



Screen 9:

Start task.



Screen 10:

Here

Specification of .prm like this

[folder_name.WF:Work_flow_name.ST:Session_Task_name]
database_connection_specified_in_workflw=Database_Schema_name_for_source
database_connection_specified_in_workflw=Database_Schema_name_for_target
Parameter_name=parameter_value




No comments:

Post a Comment