Interested to Buy Any Domain ? << Click Here >> for more details...
WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE
AND UPDATE OVERRIDE ?
- 7 Answers
- 34193 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
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What do think which one is the better joiner or look up?
What are the different types of transformation available in informatica.
How to start a workflow using pmcmd command?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Define pmcmd command?
pmscmd startworkflow -sv
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is the status code in stored procedure transformation?
Explain your project of banking domian.
Explain load alternative records / rows into multiple targets - informatica
What are the types of presistent cache in look up tr.
what is the size ur source like(file system or database)? how many record daily come u r banking project?
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 ?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
