Interested to Buy Any Domain ? << Click Here >> for more details...
with out using update strategy transnsformation how to
update the data in mapping level
- 1 Answers
- 4742 Views
- I also Faced
- E-Mail Answers
Answer Posted / guest
By using target update override and by using sessions
property treat source rows as update.by using this options
we can update the data
If any statement is wrong try to correct it
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
To import the flat file definition into the designer where should the flat file be placed?
What is transformation?
What all join we can perform in LOOKUP transformation?
What do you mean by blocking transformation?
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 joiner transformation?
How can we create index after completion of load process?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Enlist the tasks for which source qualifier transformation is used.
Differentiate between source qualifier and filter transformation?
What are the different types of olap? Give an example?
Whats the difference between informatica powercenter server, repositoryserver and repository?
How do you use reject loader.
explain about unit testing? in real time?
How do we call shell scripts from informatica?
