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 server's hard disk became corrupt and was no longer bootable, nor repairable to the point where it's bootable.  I have a complete disk image of the unbootable volume.  I also have a bootable image of that same server but it's a few months old and [More]
Hi Gurus, My client has the following requirement.Sales BOM with header pricing has to be configured for standard order, free of charge, credit memo req, debit memo req, returs order types. I have configured the BOM for standard order(ZOR) successful [More]
Hello. Yesterday i made a pacman -Syu that upgraded many packages, after rebooting, i found out that many things got broken, like the keyboard, that got a strange keymap and i can't change it, at least not by the regular ways. Chromium doesn't start, [More]
Suddenly I've started getting the error "The files are on a volume that does not support Trash. Would you like to permanently delete the item?. iMAC OSX 10.9.4. LR 5.6, Camara Raw 8.6 Any idea? Please Help Me... Thanks in advance JoseThis is how I so [More]
Hi, can i assign a password to pdf files that created with smartform? Thanks.Hi Chenna, Thank you very much first of all. i examined RSTXPDFT4 program but the FM that CONVERT_OTFSPOOLJOB_2_PDF has no parameter to assign a password to pdf. is there an [More]
Hi, I have developed some dashboard content on sharepoint 2010. I want to be able to display the content on a networked smart tv.  Ideally there would be three different pages and the Tv would cycle through each of the pages, every 5 minutes. Does an [More]
Hi All, I am loading data for application component 11, 12, & 13. Filling up of set up table for application component 12 is taking very long time. So i am thinking of taking alternative path. Say; The company has following Sales Organization -- 1100 [More]
In my BSP for a service notificaiton, I have the need to add a object that will display the document flow from the notificaiton. In addition the requirment is to be able to retrieve the sales order number from the flow and use it to callup the sales [More]
Is it absolutely necessary to configure the 10.1.3 installation to have the 10.1.2 HTTP server serve up the pages for 10.1.3? What applications need to be added to the mod_oc4j.conf? -Related to the last question- When we did the SOA suite installati [More]
I have a number of domain aliases but I have to create a seperate mailalternateaddress entry for each user to receive mail under that domain. Main domain is msai.mea.com. fang.msai.com is a domain alias and points to msai.mea.com. If I have a mailalt [More]