How will you update the row without using update statergy?
- 10 Answers
- 12173 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / bobby
I think in the session Properties, we can update or insert
the record with out using update strategy in the mapping.
I think it works. If i am wrong let me know
| Is This Answer Correct ? | 22 Yes | 0 No |
Answer / sweta kedia
In target,there is a update override option of updating the
records using the non-key columns. Using this one wecan
update the records without using update strategy t/r
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / g. manthiramoorthy
You can set the property at session level
"TREAT SOURCE ROWS AS: "Update"
| Is This Answer Correct ? | 8 Yes | 0 No |
1) If the target table doesn't have primary key, then using
update override we can update the records.
2) If target table have primary key, then we have option
called update else insert in session properties. Based upon
that we will update the records.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / shiv
you can set the property at session level TREAT SOURCE ROWS
AS 'DATA DRIVEN'. BECOUSE WE CAN SET UPDATE AT MAPPING
LEVEL AND SESSION LEVEL.
| Is This Answer Correct ? | 3 Yes | 5 No |
Answer / balaji
Hi,
Yes. Following above answers.,
We have to keep the checkmark for Update and also needs to
keep Load source as "Data Driven". Moreover, we need to also
take care that target updating table is getting updated
based on one or more Key value in it.
Thanks,
S Balaji.
| Is This Answer Correct ? | 0 Yes | 5 No |
Explain what are the different versions of informatica?
Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance
suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping?how
Explain pushdown optimization and types in informatica
How to start a workflow using pmcmd command?
How to enter same record twice in the target table,explain?
write a sql query following table? col1 col2 1 2 1 2 1 2 3 4 3 4 5 6 i want the output like unique duplicate col1 col2 col1 col2 1 2 1 2 3 4 1 2 5 6
Can we create a Integration service without a Repository service and vice versa?
What is the status code in stored procedure transformation?
why we use informatica in our project?
What are roles and groups and benefits of using them?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Teradata 
