Geeks Talk

Prepare for your Next Interview




update strategy

This is a discussion on update strategy within the Data Warehousing forums, part of the Databases category; In the update strategy, instead of using DD_INSERT I put the value as 1. Will this work?...


Go Back   Geeks Talk > Databases > Data Warehousing

Register FAQ Members List Calendar Mark Forums Read
  #1 (permalink)  
Old 03-23-2008
Junior Member
 
Join Date: Mar 2008
Posts: 22
Thanks: 1
Thanked 2 Times in 2 Posts
tanya_j is on a distinguished road
update strategy

In the update strategy, instead of using DD_INSERT I put the value as 1. Will this work?
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 03-25-2008
Contributing Member
 
Join Date: Dec 2007
Location: INDIA
Posts: 36
Thanks: 1
Thanked 6 Times in 6 Posts
cme_prak is on a distinguished road
Re: update strategy

Hi,

no,

DD_INSERT - 0
DD_UPDATE - 1
DD_DELETE - 2
DD_REJECT - 3

In Lookup[if u enable Dynamic Cache, the NewLookupRow default port is created]

NewlookupRow - 0[No Change]
NewlookupRow - 1[Insert]
NewlookupRow - 2[Update]

Thx,
Prakash
Reply With Quote
Reply

  Geeks Talk > Databases > Data Warehousing


Thread Tools
Display Modes


Similar Threads

Thread Thread Starter Forum Replies Last Post
Update strategy transformation Muthu3180 Data Warehousing 0 01-10-2008 05:40 AM
Test Strategy vijenjoy2k2 Testing Issues 1 10-24-2007 03:48 AM
Scenario on Update strategy..? sanghala Data Warehousing 2 08-27-2007 01:54 AM
Test cases Strategy rose Test Cases 6 03-01-2007 03:26 AM
Update strategy transformation JobHelper Data Warehousing 1 02-03-2007 04:17 AM


All times are GMT -4. The time now is 10:13 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Copyright © 2008 GeekInterview.com. All Rights Reserved