Sitemap

Amicuk Programming Answers

Lookups and Indexes??

-0001-11-30   Views:0

Advertisement

Hi Everybody, I am on OWB 10gr2. If we need to use lookup on source table, do we bring the lookup table to stagging area? As we stage table/view for look up need on OWB, do we build our own index in stagging schema? Do we need to match OWB index with

Hi Everybody,
I am on OWB 10gr2.
If we need to use lookup on source table, do we bring the lookup table to stagging area?
As we stage table/view for look up need on OWB, do we build our own index in stagging schema?
Do we need to match OWB index with existing index on source schema (data base)?
Even if I have unique indexes on lookup table, I am gettinng "Warning VLD-1603: Lookup Condition for Key Lookup ......" during map validation. The execution goes ok.
What can we do for such warnings?
RI

The replay answer
Advertisement
Hi,
If we need to use lookup on source table, do we bring the lookup table to stagging area?If you access your source via database link and the performance is ok, I would do the lookup in the source system. Otherwise you have to load the source table into the dwh.
As we stage table/view for look up need on OWB, do we build our own index in stagging schema?In staging area, only build the index you need for the lookup. If it is a small table you may not need an index at all.
Do we need to match OWB index with existing index on source schema (data base)?see above
Even if I have unique indexes on lookup table, I am gettinng "Warning VLD-1603: Lookup Condition for Key Lookup ......" during map validation. The execution goes ok.This warning does not appear when you do a lookup using a primary key. In my opinion it should also not appear when you do lookup using a unique index. So just ignore it.
Regards,
Carsten.

Go to See the other 2 answers

Lookups and Indexes??

Category:DefaultRelease time:-0001-11-30Views:130

Hi Everybody, I am on OWB 10gr2. If we need to use lookup on source table, do we bring the lookup table to stagging area? As we stage table/view for look up need on OWB, do we build our own index in stagging schema? Do we need to match OWB index with[More]

Lookup using indexed fields

Category:DefaultRelease time:-0001-11-30Views:130

I am doing a NamedCache.entryset(Filter) where I am trying to look up based on an indexed property. Is there a way to delegate this call to the backing cachestore if the cache is configured to have one? Right now, if its not found in the cache, it re[More]

Performance drop around 20% after adding an index

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I have an xml file (around 300 Kb, 3500 Nodes), the application internal works with dbxml handles but for display purposes I need xpaths for each node. First I was calculating them on request, but for requests with a lot of nodes it just takes to[More]

Is it possible to create indexes & use them on xml docs with namespaces?

Category:DefaultRelease time:-0001-11-30Views:130

I have put an XML doc in a BDBXML container which looks like this: *<ns1:note xmlns:ns1="http://www.testsch.org/ns">* *<ns1:to>Eric</ns1:to>* *<ns1:from>Brendan</ns1:from>* *<ns1:msg>How r u?</ns1:msg>*[More]

Having a problem with creating/using a primary key on a view

Category:DefaultRelease time:2015-10-11Views:130

I have a problem with a primary key on a view I created the view and primary key as follows: CREATE OR REPLACE FORCE VIEW "MDD"."ROCK_LU" ("DESCRIPTION",      UNIQUE ("DESCRIPTION") RELY DISABLE,      CONSTRAINT &qu[More]

Problem with sp11, wl 5.1, apache and server root requests

Category:DefaultRelease time:2015-10-11Views:130

We have the following server configuration: Solaris 2.6 Java 1.3.1_02 Weblogic 5.1 Apache 1.3.20 We recently moved from sp9 to sp11, and noticed a change in the behavior of the Apache-WL bridge (mod_wl_ssl.so). We have apache running in front of our[More]

Xquery evaluation

Category:DefaultRelease time:-0001-11-30Views:130

I'm trying to execute the xquery function 'GuidsReferencingTo' (code is below) and getting this error ''Error: It is an error for the context item to be undefined when using it [err:XPDY0002], <query>:42:58'. The error happens in the function 'GuidC[More]

IP related to Nigeria?

Category:DefaultRelease time:-0001-11-30Views:130

Hi, in February 2014 I noticed in the recent account activities details of my gmail account that my email account was obviously accessed via moble device from IPs related to Nigeria (93.186.31.82 ; 93.186.23.81; 93.186.23.82 and 93.186.31.99). After[More]

Typical Dimension

Category:DefaultRelease time:-0001-11-30Views:130

Hi The tools we are using are OWB 9.0.2.56 for ETL and Oracle Express 6.3.4 server, RAA/RAM and Oracle Express Web Agent. The database is Oracle 9i I have to design a very typical dimension for the following requirements which I guess should be commo[More]

Reliable Timing in Effect Render function

Category:DefaultRelease time:-0001-11-30Views:130

Hi, we develop a tracking effect that needs to overlay information on a layer that exactly fits the frame timing of the source material. is there a reliable way to get the information which SOURCE frame is used in the Effect render function? The Laye[More]

XmlManager::createIndexLookup with operation other than XmlIndexLookup::EQ

Category:DefaultRelease time:-0001-11-30Views:130

I have an index on attribute node: flags = DBXML_INDEX_NODES * -1 # hack, must be unsigned; don't know how to achieve it other way. Anybody knows how do it in Python. self.container = self.mgr.createContainer ( self.dbname, flags, XmlContainer.NodeCo[More]

Hot
My Ipod touch is not syncing properly.  I download podcasts and it will not allow me to delete some shows after they have been listened to.  It is a neverending cycle of deleting unwanted podcast episodes from itunes on the computer, plugging in my i [More]
Dear All,             While processing return sales for sales kit (IS R),which contains two sub items,pricing is done for main item,sub items are not there in invoice as they are not relevent for pricing but what if i need to create return order of o [More]
I installed J2ee version of Oracle9iAS R2 for windows. When I start my application server, I always get the error "Error starting HTTP-Server: Address in use: JVM_Bind". In the previous version, if I met this message, I can change the port numbe [More]
Please help me..?! My iphone 4 is low battery so i'm charging for 8 hours and i turn on it..But the iphone 4 can't turn on..!! Please help me..!!Try Reset: Hold down the Sleep/Wake button and the Home button at the same time for at least ten seconds, [More]
After I open and read an email using my mail app, how do I get back to the email app to open an read others.  I am closing the email open, going back to the home screen and reopening the mail app every time.  There's got to be a better way to do this [More]
I'm a novice Solaris system admin, so I could use some help. I've got a Sun 420R that has an older Solaris 10 installed on it. I'm trying to update the system to a clean install of the 05/09 release. The Sun 420R is on the HCL, so I'm surprised I'm h [More]
I was wondering if there are any guidelines or best practices for customizations to the RPD for BI Applications. The guidelines are clear for the physcal BAW and ETL components. I have been unable to find anything in any of the documentation pertaini [More]
Hi, I�m on the final project of my degrees. I have to develop a system to generate client side validations and server side validations for n-tiers Java applications. The principal objective of the project is: write the validations rules ones and use [More]
Hi there! I guess the subject may be a bit confusing, but let me tell you what I'm looking for. I've started learning japanese language. I found the option to use japanese in my MacBook Pro. I want to create a database of new words that I learn using [More]
Like everytime I buy am thing on the iTunes Store I get double or tripe charged for of why is thatWelcome to the Apple Community. Select the content which is causing a problem and use the 'Report a problem' button in Your Purchase History on your com [More]