Home » Developer & Programmer » Warehouse Builder » How to import flatfiles,xml......... (10gR2)
How to import flatfiles,xml......... [message #343477] Wed, 27 August 2008 06:53 Go to next message
singh.neerajin
Messages: 26
Registered: April 2008
Location: noida
Junior Member

Hi All,

I am new to the datawarehousing. I am using OWB R2 & would like to know how we can import the Flat files the repository created. i would like all import the flies in the database.

And how the schema would be created for that files.

I had worked on 9i , in that we use to import through sqlloader.

Thanks
Neeraj
Re: How to import flatfiles,xml......... [message #343838 is a reply to message #343477] Thu, 28 August 2008 05:55 Go to previous message
aajk
Messages: 7
Registered: July 2007
Location: India
Junior Member
Hi

You need to go to the Files field in OWB target module. There you need to right click and select the option import.

Before that you need to create a file location also

While importing give the flat file name and do the sampling. In each step what to do is clearly explained in the interface.

After importing use a mapping to load to a table. It is in sql loader mode(default) if the mapping has a flat file

Otherwise there is external table option also.....


Regards
John

Previous Topic: runtime repository error
Next Topic: where can i get list of propertyname ? OWB 10.2
Goto Forum:
  


Current Time: Wed Nov 26 02:01:55 CST 2014

Total time taken to generate the page: 0.10734 seconds