If in a workflow i have n number of sessions and each
session is configured with different different stop on
errors (say 5,8,10 etc respectively).How can make all this
same for all the sessions with out actualy touching each
and evry session ?
- 1 Answers
- 7872 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / lvpr
we have a variable $PMSessionErrorThreshold, in session
properties - config object for stop on errors paramterize
it to $PMSessionErrorThreshold.
If you want to change valuve, then change it in parameter
file with out editing workflow or session
hope this helps...correct me if i am wrong.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Explain joiner transformation in informatica
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What is a stored procedure transformation?
What is meant by lookup transformation? Explain the types of lookup transformation?
What is the difference between writing a joiner query in ANSI style and THETA style?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
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
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is workflow? What are the components of the workflow manager?
EXL informatica Questions
What is a sequence generator transformation?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What is aggregator transformation in informatica?
Informatica settings are available in which file?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
