IN THE NAME OF GOD Hello. I have another question.How can I transmit a performed project at warehouse builder (that is on a machine), to another warehouse...
Perhabs anyone can help me Because I'am new with OWB I got some troubles. I have two source tables one is Countries_stg (from Oracle 9i Database) the other is ...
Hi, When I try to do some simple mapping and generate the codes, I encountered this : "please select an attribute group", anybody know how to solve it?...
IN THE NAME OF GOD Hello.Very thank you for your guidance. I checked this file section and I have studied owb_cookbook approximately(chapters 11 & 12).I use...
Dear Friends, Hi, I am facing problem in slowly changing dimension. We have a hierarchy starting from "Region -> State -> Union" in Dimension DIM_UNION. In ...
IN THE NAME OF GOD Hello. I am new with data warehousing and oracle9i warehouse builder.I have some questions. I glad, someone guide me. Is there any...
Just came back from my testing Centre after passing my Oracle ...It has been a breeze.... For my preparation i used hotcerts.com Guides & transcenders......
Hi, We're recruiting people for the data warehousing project with our client in South Africa. If your background matches with below mentioned requirement so,...
Hi, We have a source table X and a target table Y. Source table X has two fields Firstname (Primary key) and Post code Target table Y has firstname (primary...
Folks, I am quite new to OWB and I'm using OWB10g to create a data warehouse on an oracle 9iR2 DB. I'm using the OWB to create staging tables and dimensions...
Hi all, i am loading 200000 records into an table through OWB. 199999 got loaded and one record failed to load. i went through the log that was created inside ...
Hi Friends, I have a follow problem when i try to create a Runtime Repository with the OWB Runtime Assitant (release 9.2, Oracle DB is 9i): - I put all data...
Hi Friends, I´m working in a ETL Project Prototype, and I'm very thankfull with all in this group !!! ... your help is really very good !!! A question, my...
Hi Friends, I did try to deploy a PROCESS FLOW and the message error from this action is: RPE-02053: The Oracle Workflow version cannot be retrieved. This may...
Hi, I want to load a lot of data from MS Access database with transformation. COuld any one suggest me whether OWB can connect Access as a source? and how? If...
Hi friends, I'm new in this group. My question is: ¿ Anybody have a instruction material or curse in PowerPoint or any format ? Thanks in avdance Rodrigo...
Passing In Variables Hi, I would like to set-up global variables to be used in severals mappings. I am new to the OWB tool and are having trouble accomplishing...
Hi, I have incoming records of the type [dept_no, description, watermark] and want to dedup them keeping the most recent record (maximum watermark). That is,...
Any thoughts on Oracle Warehouse Builder 10g Release 1 (10.1)?? I've used release 9.0.4 in which I came across some bugs, in release 9.2 there were none that I...
Dear group I am working with oracle 9i. i have been assigned to create the ETL processes. My source database is oracle 9i and also my target database is...
Hi I am new to OWB, I tried a small prototype, having 3 tables in my source db and 1 table in the target. I created the mappings and after validating,...
Hello Group members I would like to post a "how-To" sceanrio every week in this group for the benefit of all users. E.g.s can be broad sections of DW...
Hello Folks Unfortunatley I am unable to create the poll in this group due to some downgrading by Yahoo I suppose. So this poll is located in a Different Group...
In OWB 9.02 the Time Dimension has the PK of the lowest level (DAY) that is a Date type (the name of the field is Time_Id) In OWB 9.2 the Time Dimension...
Hi all, I worked as an ETL developer using Informatica now i am trying to learn OWB,i know the entire ETL process buti dont know how to use OWB, so far i...