Interested to Buy Any Domain ? << Click Here >> for more details...
what is target update override and when we use it?
- 2 Answers
- 6934 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / ankur saini er.ankur861@gmail.
Hi
Even if the table has key columns but as per some
requirement you dont want to update the records based on
that key column in this scnario also we can use update
overide to update the records based on our desired column
(s) other than primary index(td) or primary key(oracle)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
what is mean by complex business rule ?
COM components can be used in Informatica
Explain dynamic target flat file name generation in informatica
Define sessions in informatica etl?
What is the difference between writing a joiner query in ANSI style and THETA style?
What are the types of caches in lookup? Explain them.
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What is complex mapping?
What are the issues you have faced in your project? How did you overcome those issues?
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 exclusive and normal mode for repository services?
What is mapping debugger?
What is Cognos script editor?
What is a stored procedure transformation?
