| help reqd.in OWB [message #93354] |
Sun, 15 August 2004 22:44  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
