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...
Is timestamp data type is supported in OWB 9.2, if yes how to add a timestamp column to a table. I try to import a table that contains a timestamp column, but...
Hi everyone, can anyone tell how we can use multiple databases as source. because from target only one dblink to the source is possible. If i want to fetch...
Hi All, I am using OWB 9.2 and Oracle 9i database. 1. Created Source Module(maps to SQL Server) and Target Module. 2. Successfully imported Tables into Source...
Hi, I am able to load the data from flat files to Oracle tables. With the same setting when I load a table to flat (a simple straight fwd pass through...
Hi All, I am doing a project at university involving building a data warehouse prototype. I have a problem in reporting from OWB client.I use warehouse builder...
Hello , I got through your article on Oracle Warehouse Builder. Good Work !! I am facing a problem with Oracle Warehouse Builder 9.2.0.8. I create the Oracle...
Is any expert help me in - How to schedule Mappings in OWB 9.0.2. Thanks in advance Sunil ... Do you Yahoo!? Yahoo! Finance: Get your refund fast by filing...
Hello All, We are implementing a Data Mart system using Oracle Warehouse builder 9.2 and Oracle 8i Database. Our source and target schemas are in different...
Hi All, 1. Can anyone help me in giving some tips on how to go about connecting to VSAM files using OWB? 2. How to connect to SQL Server in OWB? THanks,...
Hello, Je work with OWB 9.2.0.2.8. I'd like to know how can i generate documentation on my project with OWB. Thanks Regards Cathy ... Yahoo! Mail : votre...
Fahd, I think you need to create a flat file module first which allows you to sample the file and create the necessary structure (i.e. columns and datatypes)....
Hello, I am doing a project at university involving building a data warehouse prototype.I design the ETL process by OWB.But now in deploying mappings, I have a...
Hello, I am doing a project at university involving building a data warehouse prototype.I design the ETL process by OWB.But now in deploying mappings, I have a...
Is there any way to use SCM to do version control of OWB metadata? OWB allows for some version control via Snapshots, but it gives you nothing like a librarian...
I am new to OWB and am trying to get up and running on it. My problem is that the documentation available from Oracle seems to be out of synch with the...
