how can we update without using update transformation.
wt is push down operation in informatica.
which lookup gives more tuning performance. if so why.
Answer Posted / sambasivarao.m
By using Update override option in Target table we can
update the table
| Is This Answer Correct ? | 3 Yes | 9 No |
Post New Answer View All Answers
What are mapplets? How is it different from a Reusable Transformation?
What is primary and backup node?
How to create Target definition for flat files?
Explain the code page compatibility?
What are the types of schemas we have in data warehouse.
What is difference between a gateway node and worker node?
What are the different lookup cache(s)?
What is joiner change?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
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 happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Separate from an archive server and a powerhouse?
in reporting we add some new objects,how we get the count of the newly added objects to the report
Did u used latest transformations of 8.6.0? for what?