WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE
AND UPDATE OVERRIDE ?
- 7 Answers
- 32031 Views
- Target, I also Faced
- E-Mail Answers
Answer Posted / vishnu_kr
Hi,
i guess the SQL override is used in the source qualifier trf
to implement joins, filter, sorter etc..
but update override is used in the Target table definition.
u use this option to update Targets that have no primary
key (hence u can't use update strategy) coupled
with 'Update as update' property in the session mappings tab
and 'Treat rows as' property set as 'Update' in the session
Properties tab.
| Is This Answer Correct ? | 25 Yes | 3 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.
How to load a Dimension ? and how to load a fact table?
Difference between Data and Index Caches?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What is a sorter transformation?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Separate from an archive server and a powerhouse?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What are the issues you have faced in your project? How did you overcome those issues?
Define mapping and session?
Define enterprise data warehousing?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What is informatica?
What is the difference between informatica 7.0 and 8.0?
