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
The issue I identified in ACR 7.1RC is not fixed in the production release of ACR 7.1.  Maybe I did not explain this in enough detail, it's very easy to miss.  1. Select a RAW file that was previously adjusted using PV2010.  When you open the file wi [More]
Hello: We are using a SQL Query Report to provide a mass update to a table. We are using the apex.collection and having it display a number of records in a SQL Query Report for mass update. We have 14 columns in the report, for which the first 11 are [More]
hi, in office 2013 professional plus, can 2 user edit 1 word document at the same time?Hi, As far as I know, multiple users can not edit Word file in the same time directly. Could you give me your demand? Please check the two follows workarounds if t [More]
Many of CS6 file association extensions wont open; After installing CS6 many of the previous extensions .psd .prproj .ai, I found broken and Windows 7 (64bit) would ask what program to open it with. It would not give me the option to chose the obviou [More]
OK, I'm very new in the Mac world and am still trying to move my photos from my PC. I burned all of the photos to a DVD-R using the Kodak gallery program. I have 3 DVDs of photos. Now I am in the process of importing into iPhoto. I opened iPhoto, ins [More]
There is no Display Duplicates in iTunes 11 - if I had known I would not have updated this is essential when adding CD's to the library - and I can find no way to contact apple as I have to have a product with a serial number to ask them a question a [More]
it seems i've moved the white line box at the top of the arrange / bar listing as far right as it wants to go - i think it's around 2137 bars is there any way of making it go further to the right? changing a song length setting maybe? thanks dual g4 [More]
Thanks Peter Spiers. I have checked the document color mode was set to CMYK and the file is created in spot colors. Previously I was using CS5.5 and have moved to CC recently. The logo artwork was created ages ago, maybe even as early as CS3?Can you [More]
We are trying to use the Batch Bursting tool and it works great for all our reports with only one DIM POV (ie Company). Running into issues trying to figure out how to burst when I have two different Dim's that I need to pass (ie Departmental Report [More]
i had a 4th generation ipod,at first all of my recent applications works just really fine until i updated it to iOS 5.0.1,most of my best applications or games crashes!!! i really don't know any reason why it keeps crashing!! i even tried updating al [More]