Members   Search   Help    Register    Login   Home
Home » Developer & Programmer » Warehouse Builder » How to Import Mainframe files in OWB (Oracle,10.2)
How to Import Mainframe files in OWB [message #390729] Mon, 09 March 2009 08:21 Go to next message
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
Report message to a moderator
Re: How to Import Mainframe files in OWB [message #391896 is a reply to message #390729] Sat, 14 March 2009 05:35 Go to previous messageGo to next message
ajitpal.s
Messages: 168
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
Re: How to Import Mainframe files in OWB [message #392038 is a reply to message #391896] Mon, 16 March 2009 02:37 Go to previous message
vengat06
Messages: 7
Registered: March 2009
Location: Chennai
Junior Member
Thanks for your information.

Venkat
Report message to a moderator
Previous Topic:Condition in Splitter operator
Next Topic:Dynamic Flat File Name(Source)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Nov 9 04:44:35 CST 2009

Total time taken to generate the page: 7.77378 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.