Home » Developer & Programmer » Data Integration » File Transformation (ORACLE WAREHOUSE BUILDER 10GR2)
File Transformation [message #277433] Tue, 30 October 2007 01:56 Go to next message
placeacall
Messages: 2
Registered: October 2007
Location: Nigeria
Junior Member
I am a newbie to OWB, so I believe I could be pardoned for this question.
Is it possible without the use of external tables or loading into a staging table to convert a flat file with 5 columns to a flat file with 3 columns. ie
convert source file has 5 columns with variable number of records to target file with 3 columns and same number of records but without using external tables or intermediate staging tables.

If possible what steps can be performed to achieve this.

Report message to a moderator

Re: File Transformation [message #277450 is a reply to message #277433] Tue, 30 October 2007 03:13 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As you've put it, I'd open this "5-columns" file in MS Excel, delete two columns and save it as "3-columns" file.

Or does it have to be done using OWB? If so, sorry - I wouldn't know how to do that.

Report message to a moderator

Re: File Transformation [message #277502 is a reply to message #277450] Tue, 30 October 2007 06:52 Go to previous message
placeacall
Messages: 2
Registered: October 2007
Location: Nigeria
Junior Member
The whole idea is to automate transformation of a flat file using warehouse builder. it is to produce a proof of concept using warehouse builder.

it is possible to wrtie unix scripts to remove the uneccesry columns but I am trying to achieve this also using warehouse builder

Report message to a moderator

Previous Topic: Importing from a file
Next Topic: Designing my dimension and fact
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 23 04:49:44 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.