Interested to Buy Any Domain ? << Click Here >> for more details...
How can u insert o ne row in the target if that row does not
exists in the target and update if it exists
- 6 Answers
- 15066 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / sudhar
Use the session properties,
In Target Properties use options
Insert
update else Insert
Check boxes.
| Is This Answer Correct ? | 15 Yes | 1 No |
Post New Answer View All Answers
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
what are 3 tech challenges/ common issues you face?
What is an aggregator transformation?
Global and Local shortcuts. Advantages.
How can we delete duplicate rows from flat files?
What is expression transformation?
is it possible to index the data in cache of lkp transformation ?
In which transformation you cannot drag ports into it?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
How you can differentiate between connected lookup and unconnected lookup?
What are the various types of transformation?
What could be the possible resons of locks by user?
What is the surrogate key?
Performance tuning( what you did in performance tuning)
