Analytics Software

Our environment is setup with Informatica and a DAC.

In our Informatica mappings we have setup a process that will process data based upon partitions (on the database). We want to setup the SQL Joiner so that the SQL will receive a parameter (*$$OIPARTITION*) for the partition it should be processing. The parameter was entered under Mappings->Parameters and Variables

ex: Sample XML

SELECT $$Hint3
OI_FS.SHIP_METH_CD,
OI_FS.CAMP_LAST_UPD_DT
FROM W_ORDERITEM_FS PARTITION(*$$OIPARTITION*) OI_FS
WHERE OI_FS.X_ROW_STATUS <> 'D'
$$Hint2

In our Informatica workflow we have setup one workflow with 8 sessions that represent the 8 partitions.

We are trying to figure out how to enter the value for the $$OIPARTITION in the workflow session so that it will pull the data from the appropriate partition in the mapping. Can you please let us know how to setup a value in the workflow session that is unique to that session (not the entire workflow) and then would be passed and digested by the mapping during the processing?

Thanks...