Home » Developer & Programmer » Data Integration » help reqd.in OWB
help reqd.in OWB [message #93354] Sun, 15 August 2004 22:44 Go to next message
Vinay Prakash
Messages: 1
Registered: August 2004
Junior Member
hi,

I am facing problem while using file type source in OWB.

I am not getting how to create target for this source and hence the mapping with the source. Can anybody help me out??

thanx...Vinay
Re: help reqd.in OWB [message #93358 is a reply to message #93354] Thu, 26 August 2004 22:33 Go to previous message
Vidyanand More
Messages: 35
Registered: January 2003
Member
Hi Vinay,
OWB config details is as follows

OWB Client Ver 9.2.0.2.8
OWB Repository 9.2.0.2.0

Let us consider we need to develop a mapping in OWB consist of Flat File (Dept.txt) as source & Oracle Table scott.dept as Target table following are steps.

1. Create a Flat File Module. Select Files object node in Object Hierarchy. Create a Flat File Module e.g. IP_MODULE. Provide Connection details this should be Dir. Create a new location for connection.

2. Import Target table Scott.Dept in Target Module.

3. Create a mapping which consist above source file as source & Scott.dept table as target.

4. Set configuration property for the mapping. This can be set by selecting the mapping & right clicking.
You need to set Source & Targets property of the mapping.

5. Validate & Generate the mapping.

6. In Deployment Manager Register Location.

7. Deploy & Execute the mapping.

Please note that you will need to create Runtime Repository Connection to access Deployment Manager.

I followed above steps & managed to upload data from Text file to Scott.dept table without any errors.

Regards,
Vidyanand
Previous Topic: how to create database using Oracle Express ?
Next Topic: OWB query
Goto Forum:
  


Current Time: Fri Mar 29 10:40:35 CDT 2024