Geeks Talk

Prepare for your Next Interview




Dynamic Lookup

This is a discussion on Dynamic Lookup within the Data Warehousing forums, part of the Databases category; When does dynamic lookup gets updated when I am in the process of moving a new record to the target(lookup table)? Is it after dumping new record into target ...


Go Back   Geeks Talk > Databases > Data Warehousing

Dynamic Lookup Dynamic Lookup

Register FAQ Members List Calendar Mark Forums Read

Reply

 

Thread Tools Display Modes
  #1 (permalink)  
Old 02-07-2008
Junior Member
  
Join Date: Feb 2008
Location: Pune
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
sakthiganesht is on a distinguished road
Dynamic Lookup
When does dynamic lookup gets updated when I am in the process of moving a new record to the target(lookup table)?

Is it after dumping new record into target or before or when?
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 02-13-2008
Banned
  
Join Date: Oct 2007
Location: Hyderabad
Posts: 176
Thanks: 2
Thanked 11 Times in 11 Posts
quality_quantity is on a distinguished road
Re: Dynamic Lookup
An improved lookup service is provided that allows for the dynamic addition and deletion of services. This lookup service allows for the addition and deletion of services automatically, without user intervention. As a result, clients of the lookup service may continue using the lookup service and its associated services while the updates occur. Additionally, the lookup service provides a notification mechanism that can be used by clients to receive a notification when the lookup service is updated. By receiving such a notification, clients can avoid attempting to access a service that is no longer available and can make use of new services as soon as they are added to the lookup service.
Reply With Quote
  #3 (permalink)  
Old 02-26-2008
Junior Member
  
Join Date: Feb 2008
Posts: 8
Thanks: 4
Thanked 0 Times in 0 Posts
tanya123 is on a distinguished road
Re: Dynamic Lookup
Hi..I think dynamic lookup will first update the cache and then insert the record into the target...
Correct me if i am wrong...
Reply With Quote
  #4 (permalink)  
Old 02-27-2008
Junior Member
  
Join Date: Feb 2008
Location: Pune
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
sakthiganesht is on a distinguished road
Re: Dynamic Lookup
Even I got the same reply from one of my colleague. Thanks guys
Reply With Quote
Reply

  Geeks Talk > Databases > Data Warehousing

« DataStage Transformer | Incremental aggregation »

Thread Tools
Display Modes
Linear Mode Linear Mode


Similar Threads

Thread Thread Starter Forum Replies Last Post
Return oen port from lookup transformation rajesh.peri Data Warehousing 1 03-24-2008 02:42 PM
Dynamic and Static lookup JobHelper Data Warehousing 3 02-08-2008 10:38 PM
Lookup Query? srinu_vasrao Data Warehousing 1 12-28-2007 02:47 AM
Multiple field lookup??? lesliep Database General 2 11-26-2007 02:46 PM
Source and Target connection value in the lookup sat.inn Data Warehousing 0 02-26-2007 03:34 AM


All times are GMT -4. The time now is 09:12 PM.

Contact Us - Geeks Discussions - Archive - Privacy Statement - Top

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