| How to Import Mainframe files in OWB [message #390729] |
Mon, 09 March 2009 08:21  |
vengat06
Messages: 7
Registered: March 2009
Location: Chennai
|
Junior Member |
|
|
Hi All,
I am Venkat. I am new to this Technology.
Could you please let me know the steps how to import mainframe files in Oracle warehouse builder.
Kindly reply.
Environment: Oracle 10.2
Thanks in Advance.
Venkat
|
|
|
|
| Re: How to Import Mainframe files in OWB [message #391896 is a reply to message #390729] |
Sat, 14 March 2009 05:35  |
ajitpal.s
Messages: 204
Registered: November 2006
|
Senior Member |
|
|
Im not sure if its possible to create a direct link from owb to mainframe.
But we can do the following.
1) Find a way to convert the mainframe data files into fixed length file. Its possible using cobol or any mainframe language
2) Move the data file to your server where owb is installed in ascii format
3) Use these text files as source to owb.
Last time, we used a tool called infomover to accomplish step2
[Updated on: Sat, 14 March 2009 07:57] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
