Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
Scenario on Update strategy..?
This is a discussion on Scenario on Update strategy..? within the Data Warehousing forums, part of the Databases category; Assume that mapping have Update Strategy Transformation where all rows are marked for ‘Update’. In session configuration, - “Treat Rows as” is set to “Insert” and target option is “Update ...
|
|||||||
08-16-2007
|
|||
|
|||
|
Scenario on Update strategy..?
Assume that mapping have Update Strategy Transformation where all rows are marked for ‘Update’. In session configuration, - “Treat Rows as” is set to “Insert” and target option is “Update (else insert)”. How Informatica will treat the rows?
Thanks in Advance Sanghala sanghala dwforum.sanghala
__________________
Sanghala If you are satisfied with my reply. Please click “Thanks” button which increases the reputation and can serve you better. 
|
| The Following 2 Users Say Thank You to sanghala For This Useful Post: | ||
| Sponsored Links |
|
08-24-2007
|
|||
|
|||
|
Re: Scenario on Update strategy..?
Generally, the transformation properties override by the session properties. So Mapping(transformation) property UPDATE won't work.
Session property will flag all the inputs rows as INSERT. Then The TGT property UPDATE else INSERT then the PowerCenter Server updates rows flagged for update if it they exist in the target, then inserts any remaining rows marked for insert.
__________________
Thx SRIRAM N Hope Everything Good
|
|
08-27-2007
|
|||
|
|||
Re: Scenario on Update strategy..?
Quote:
Sriram, Thanks a lot for your valuable inputs... Finally you will say that - Update else Insert will work for this scenario. www.sanghala.com
__________________
Sanghala If you are satisfied with my reply. Please click “Thanks” button which increases the reputation and can serve you better.
|
 |
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to update more than one row with a different value | Geek_Guest | SQL | 12 | 4 Days Ago 05:50 AM |
| Test cases Strategy | rose | Test Cases | 9 | 2 Weeks Ago 08:09 AM |
| Update strategy transformation | JobHelper | Data Warehousing | 1 | 02-03-2007 03:17 AM |
| Kindly update me the Limitations | christia | Unix/Linux | 1 | 09-13-2006 11:33 AM |
| Kindly update me the use of this Program | Remasri | Unix/Linux | 1 | 08-11-2006 04:14 AM |
All times are GMT -4. The time now is 10:38 AM.
