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
Hi, I have been using officejet pro x476dw for 6months, and I figured out that I can't scan 2-sided legal sized document. Is it impossible to scan 2-sided legal size documents on ADF? Do I have to scan them MANUALLY? If this machine doesn't support 2 [More]
HI, I have created a 310 page book using Indesign CS5. Now that the book is complete, I need to export it to PDF for printing. I have been working on this for about a week and I have tried to export the book at least 20 times, and only once did it wo [More]
Hello, Would like to know if there is a way of throwing an exception with severity severe so that the calling PAPI call will get the error back. Thank you in advance your you suggestions. Edited by: user8913595 on Mar 3, 2011 11:54 AMUsing admin cent [More]
Can anyone tell me how to delete a book once you have finished it delete from the ipad alltogetherYou should have an Edit button at the top right of your bookshelf in the iBooks app, which should allow you to delete books directly on the iPad. If you [More]
i've been getting the this error 0xC000000D. the topic at http://social.technet.microsoft.com/Forums/windows/en-US/ce8f9d22-b5cc-4378-8e97-92d615030b5c/session-microsoft-security-essentials-oobe-stopped-due-to-the-following-error-0xc000000d-using has [More]
Dear Experts, Recently, when I execute my intergrated planning query, I had the above error. I have searched the whole SDN for solution and I found many threads and solutions. I have tried all the solutions and still I have the error even after all o [More]
I am currently working on abode air for making an app for ios. I am trying to add Tapjoy and it requires two framework MediaPlayer.framework and CCTelephoneNetwork.framework i have added them in my xcode project in build phases -> link binary with li [More]
Hi experts,     How to change columns to rows and row to columns in executable program . Any function modules(se 37) or any class(se24) are there please give me suggestions. Thank you, dinesh reddy.Hi, Use this FM in your ABAP code CALL FUNCTION 'ALS [More]
Hi I ve got a table in the following format: 1 2 3 1 4 5 2 2 1 2 5 6 and I want it in that format: 1 2 3 4 5 2 2 1 5 6 is there a way to do it? Thank u very much KAs a wise man once remarked, "Re: problem in displaying row vale as column name" C [More]
Hi everyone, Please can someone provide me with a fix for the latest annoyance I've discovered on my Q10. Whenever I enter the wifi area at work, all my email accounts are taken off line. The network is NOT one of my saved networks, so I can't simply [More]