Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to Handle Header record date for flat file - OWB

Status
Not open for further replies.
Beantree

Beantree

Programmer
Feb 27, 2001
95
US
Can anyone help with how to do the following in Oracle Warehouse Builder?

I need to use the header record of a flat file and take a date value from it, and insert that date as a new field in the detail records during the mapping to the staging area.

I have a field that identifies header/detail records.

Please advise how to accomplish this.

Thanks.
 
Status
Not open for further replies.

Similar threads

RJKumar
  • Locked
  • Question
How to build Dimensional model for commission received and return
Replies
1
Views
754
johnherman
johnherman
Ulianna
  • Locked
  • Question
Loading files from different sources into one database table
Replies
1
Views
349
johnherman
johnherman
Vivarto
  • Locked
  • Question
Modelling Order Header attributes
Replies
0
Views
711
Vivarto
Vivarto
ye9out
  • Locked
  • Question
How to choose solution 1
Replies
5
Views
711
blom0344
blom0344
dbrs4me
  • Locked
  • Question
Book Search - Oracle OWB and OBIEE
Replies
0
Views
213
dbrs4me
dbrs4me

Part and Inventory Search

Sponsor

Back
Top