Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between session variables and workflow variables?
- 2 Answers
- 20611 Views
- Informatica, I also Faced
- E-Mail Answers
Answer Posted / jlt
A workflow variable can be used accross sessions inside
that workfow..whereas a session variable is exclusive only
for that particular session
| Is This Answer Correct ? | 20 Yes | 0 No |
Post New Answer View All Answers
What is the way to execute pl/sql script using informatica mapping?
Different circumstance which drives informatica server to expel records?
How to Create a folder using pmrep command?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Explain the informatica workflow?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Explain what is informatica metadata and where is it stored?
During the running session, output files are created by informatica server. Enlist few of them.
Enlist few areas or real-time situations where informatica is required.
What is event and what are the tasks related to it?
wat are deployement groups in informatica, how it will be used for developers
Write the unconnected lookup syntax?
CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks
