what do u mean by meta database??????? lalalulu24 <lalalulu24@...> wrote: Dear All, I need to generate a Meta Database out of the existing Source and ...
428
lalalulu24
Aug 23, 2005 4:20 am
Well basically I need to extract the Meta Data out of the existing source, staging, and target databases. This is for reporting and statistics purposes. ... ...
429
Michel Boire
mboire
Aug 23, 2005 6:50 pm
You already have reports on all the objects available through the Web Warehouse via Builder Design Browser, see --> Oracle9i Warehouse Builder Installation and...
430
lalalulu24
Aug 24, 2005 1:22 am
Thanks MB, I will give that a try! Larry...
431
Sankara Narayanan
sankaran_aru...
Aug 26, 2005 3:53 pm
I have specified the file in a unix directory as the target. The mapping was run and the target file was created in the specified location in the unix. OWB was...
432
Sudipta Chatterjee
sudipta_cht
Aug 27, 2005 7:16 am
Hi, I am not sure of the method through OWB settings, etc., but you could run a post-mapping process that will set the required permissions. Tell us how you...
433
kamal kamal
minimeu2003
Aug 27, 2005 10:41 pm
if this is a scheduled process and the name of the file is the same, then u can do a file watcher in unix and change the permissions. this is how we do it... ...
434
Sankara Narayanan A
sankaran_aru...
Aug 29, 2005 12:54 pm
Hi, The following steps solved the problem! Telnet to the database machine as the OS user who started the database listener process and issue command umask 022...
438
abba_erp
Sep 13, 2005 2:28 pm
Oracle Warehouse Builder for UK ( Longterm Onsite) skills : Oracle Warehouse Builder exp : 5+ years location : UK Position : Permanent pl send ur cv/resume to ...
439
Sankara Narayanan
sankaran_aru...
Sep 14, 2005 3:42 pm
Hi, Is there any general recommendation to use oracle sequence over OWB sequenc in terms of performance? Thanks, Sankar...
440
Sankara Narayanan
sankaran_aru...
Sep 14, 2005 3:56 pm
Hi, What is the general procedure for upgrading from the evaluation version, after getting the license from oracle? Is just providing the license number...
441
jpais79
Sep 14, 2005 6:37 pm
I have a query for which I need to develop a mapping for: it looks like this: SELECT DISTINCT a.employee_id FROM employee a WHERE not exists( select 'x' from...
442
Sudipta Chatterjee
sudipta_cht
Sep 14, 2005 6:51 pm
I get a feeling that a set minus should be your answer... but there has to be a self-join ... I have a query for which I need to develop a mapping for: it...
443
kamal kamal
minimeu2003
Sep 14, 2005 9:40 pm
we have used both and there was no distinguishable change in performance... Sankara Narayanan <sankarsuresh@...> wrote:Hi, Is there any general...
444
seshpalli srinivas
coolcnu
Sep 15, 2005 1:56 am
use join operator to join tables A and B and then use filter and then use deduplicator. jpais79 <jpais79@...> wrote:I have a query for which I need to...
445
Sankara Narayanan A
sankaran_aru...
Sep 15, 2005 4:51 am
Thanks for the information Kamal. Is there any difference between the following two approaches: 1) Import the Oracle Sequence and call it from OWB. 2) Use...
446
abba_erp
Sep 15, 2005 5:33 am
Oracle Warehouse Builder (OWB) needed for UK ( Permanent Position) skills : Oracle Wareshouse Builder ( OWB) exp : 5+ years location : UK Permanent pl send ur...
447
jessica pais
jpais79
Sep 15, 2005 1:03 pm
hey, Thanks for the reply but what would be the join condition if I had to join the two tables. seshpalli srinivas <coolcnu@...> wrote: use join operator...
448
seshpalli srinivas
coolcnu
Sep 15, 2005 4:49 pm
join on key columns. I think in your case it should be on emp_id...
449
jessica pais
jpais79
Sep 15, 2005 5:21 pm
Hi srinivas, Is it a problem if we do not add a join condition to the joiner..(where I joined the employee_id from table a and employee_id & employee_id_2 from...
450
seshpalli srinivas
coolcnu
Sep 15, 2005 6:02 pm
could you give me the warning message...
451
janak Bhawnani
janak_y
Sep 15, 2005 9:14 pm
Mostly its not Ok from a logical and functional perspective to have a joiner without join condition because it will generate a cartesian product between two...
452
jessica pais
jpais79
Sep 16, 2005 1:20 pm
Thanks !! but if that is the case, then how would you develop a mapping for this particular query: SELECT DISTINCT a.employee_id FROM employee a WHERE not...
453
janak Bhawnani
janak_y
Sep 16, 2005 3:42 pm
Interestiing !! Let me understand the requirement.Based on ur query I see that there is only one table employee with two columns in concern- employee_id and...
454
Ardi M
m_arsyad
Sep 20, 2005 5:40 am
Hi All, Could you help me in this case ? My configuration details is as follows: Oracle 9i Warehouse Builder Client: 10.1.0.2.0 Oracle 9i Warehouse Builder...
455
Sudipta Chatterjee
sudipta_cht
Sep 20, 2005 7:16 am
Ardi, When you register the location in the deployment manager, make sure that you are providing the "\" at the end of teh directory path. I think that is the ...
456
kamal kamal
minimeu2003
Sep 20, 2005 9:40 pm
and also did u deploy the connector as the directory????? Sudipta Chatterjee <sudipta_cht@...> wrote:Ardi, When you register the location in the...
457
Ardi M
m_arsyad
Sep 21, 2005 2:27 am
Thanks to Sudipta and Kamal for your help.. Today I can do it... Basicly my problem is when I used Deployment Manager to deploy and execute the mapping, I...
459
satyasurendra
Sep 22, 2005 9:14 am
I have a requirment, where i need to read data from 4 different sources (DB2,ABAP,sqlserver,terradata) which are of same table structure i need to load the...
460
sachin_garg
Sep 22, 2005 7:04 pm
Satya, I'd imagine all you need to do is to create 4 different source modules, one of each database type you need to pull data from and pull them into one...
