I have developed mappings to extract data monthly from the source to target by passing the paramter='OCT-12'
so for all the mappings i have to change the mapping parameter to OCT-12 every month before running session is there any way we can pass the parameter dynamically so that it will impact for all the sessions..
Please help me if any one know about this it will reduce my efforts and cosume the time for me.
Thanks in Advance,
If the value is parameter date is a date then U can use the informatica data function to do the data flow and schedule the wf to run on particular date of the month so that the date function will take the run date as the parameter.
Hope this will give an hint.
In some cases i need to extract previuos month data then it wont work right
I think Parameter File Concept will work here but i never used it i need to know how to configure or define it in informatica....
Create a mapping and to get the date and load it into the target(Flatfile with .prm extn) .the output should be below
Dateparam = 01-Nov-12
Create a parameter in the existing mapping and use that in the SQL override.
The workflow has to designed in such a way to run the S1( extract date) on the start of every month.Yo can achive this with the help of decision task.
Then S2 will use the param file which is generated by S1.
I am with you, the date is variable that can change the at any time and with out any manual inputs,
this cannot happen, so there are few approaches,
1) Create a manual parameter file and use.
2) Create some flag/control file with date in that and run the wf
3) Create a control table in the date base and use that as a source to create date filters/ parameter file
4) If ur using any 3rd part scheduling tool then just make a parameter file for that rundate
5) A date file that have the date for which the wf need to execute for
Note: We are following the 4th approch to run the adhoc jobs where the date will come from the scheduling tool..
Hope this will help U