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...
461
lalalulu24
Sep 23, 2005 11:11 pm
Dear All, How do I Reconcile the Metadata???? Every time Reconiliation runs I will like to run the Metadata report to capture new change and what all changed....
462
p_arvind
Sep 27, 2005 1:31 am
We are looking for a strong ETL Developer with overall experience of atleast 5 years with minimum of 2 years in Data Warehousing and OWB. Other required skills...
463
anand
anandsreeram
Sep 27, 2005 9:29 pm
Hi All, Can I restrict access to a user only to a particular project in OWB? Thanks,...
464
kamal kamal
minimeu2003
Sep 27, 2005 9:57 pm
hi, i know that we can do it at a repository level. dont know about project level though.... thanks kamal anand <anandsreeram@...> wrote: Hi All, Can I...
465
bokkakesballa
Sep 30, 2005 1:54 pm
Hi, this is my first message on this mailing list... i must create a procedure that make a select from 2 tables. An e.g. of my code is this: CREATE OR REPLACE...
466
kamal kamal
minimeu2003
Sep 30, 2005 8:29 pm
what r u trying to do with this procedure..u must be getting the error while running the map..where exactly r u getting the error message??? bokkakesballa...
467
janak Bhawnani
janak_y
Sep 30, 2005 9:02 pm
hi apparantly its an issue where ur select query is returning more than one rows .The query does select INTO <nome> . The result of any code like this in...
470
bokkakesballa
Oct 3, 2005 1:10 pm
hi, my problem it's due to with pl/sql procedure not created with OWB, my procedure it's created by me with toad...the first solution it's correct and have...
471
sri_kon
Oct 5, 2005 10:40 am
Hi All, I have installed OWB downloaded from the Oracle website. I am now looking at building a sample warehouse from scratch. Can anyone please let me know...
472
lalalulu24
Oct 7, 2005 8:40 pm
Dear All, I will be obliged if you could share your knowledge with me on the following matter: I need to capture the details about: - when an Inbound or...
473
David
dave_near
Oct 25, 2005 5:41 pm
Hi All, We are currently doing a test between Oracle 7.3 and 9i databases. The OWB is installed in 7.3 database. During the Runtime Repository creation, in...
474
rishna_jobsin
Oct 28, 2005 11:53 am
Hi All, We are a Leading Resource Consultant catering to various MNCs in India and Abroad. We are looking for Our PCMM Level 5 Client in U.S. [CANDIDATES...
475
S
sixthjan
Oct 31, 2005 3:59 pm
Hi, I do not see the "OEM register" button after generating and deploying the process flow ( or the mappings) in OWB. Anyone has any idea what to do to...
476
OracleWarehouseBuilde...
Nov 1, 2005 2:31 pm
Hello Group member Great to have you as a group member of this knowledge based network group. Would you be interested in sharing your knowledge, the challenges...
477
OracleWarehouseBuilde...
Nov 1, 2005 2:31 pm
Members, Please refrain from posting messages that are irrelevant to the to the OWB group's interest. This group is exclusively targeted for OWB professionals....
478
kalmanje harinath
kalmanje_h
Nov 2, 2005 5:02 am
Hi S Using "oem_exec_temp.sql" script, write a wrapper PL/SQL block, which can scheduled in OEM as a job. U can find this script file in <OWB_HOME>\bin...
479
Rekha
reks_r1
Nov 2, 2005 8:59 pm
Hi all, I have installed OWB 10G. I am trying to run a simple map to load data from EMP table scott schema to another table(emp_test) in test_tgt schema. No...
480
Sudipta Chatterjee
sudipta_cht
Nov 3, 2005 3:45 am
Hi, Are you able to validate the mapping from its editor? Can you deploy it? Or are you getting the error just at runtime? This might help us better udnerstand...
481
Rekha
reks_r1
Nov 3, 2005 5:24 pm
Hi, Thanks for your response. I was getting this error at the time of deployment. But I think the error was due to wrong configuration of runtime repository &...
