How to load field from a CSV Header record to all imported Detail records in the file
I'm loading a Fixed Width data file to Stage for Transaction matching. This file has: HEADER record that has the transaction_date in it. multiple DETAIL records with transaction type and amounts...
One technique for this sort of thing. is to set a Business Rule on the Amount dimension, so it runs on every line. When it finds the "date" line, it stores the value in the Globals object. Then, another rule assigned to Time simply retrieves and returns that value.
