How will you update the row without using update statergy?
Answer Posted / g. manthiramoorthy
You can set the property at session level
"TREAT SOURCE ROWS AS: "Update"
Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
Define filter transformation?
How you can differentiate between connected lookup and unconnected lookup?
Parameter and variable differences
What do you understand by term role-playing dimension?
list out all the transformations which use cache?
Why update strategy and union transformations are active? Explain with examples.
How to generate sequence numbers?
can we override a native sql query within informatica? Where do we do it?
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 is the different lookup cache(s)?
How to do unit testing in informatica?
difference between informatica 8.1.1 and 8.6
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is the sequence generator transformation in informatica?
What is primary and backup node?