Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / ravi
if it is parallel batch entire batch will failed.
if it is serial batch current session only will failed.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
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
What are the informatica performance improvement tips
What are data-driven sessions?
What is a mapplet/worklet in informatica?
Is stop and abort are same in informatica?
What are the main issues while working with flat files as source and as targets ?
What is the Process to creating lookup transformation in informatica
In informatics server which files are created during the session rums?
How many dimensions are there in informatica?
What is different between the data warehouse and data mart?
What are the types of lookup transformation?
what is mean by complex business rule ?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What is difference between a gateway node and worker node?
What is a transaction control transformation?
