The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Keyser_Soze
2 years agoContributor
Where does data get stored before arriving to the Staging Area ?
During the import step of a workflow profile, where does data gets stored before arriving to the staging area ?
I am using an Event Handler to manipulate loaded data before it gets saved to the staging area. However, I am unable to retrieve it before it gets stored into 'SourceStageData' Table.
Data appears in the database only after the operation named 'WriteTransformedData'.
- Are loaded data rows stored in memory and processed, then gets saved to the table 'SourceStageData' after operation 'WriteTransformedData' ?
- How can I access the loaded data before it gets processed (parse and 1st transformation during 'Import' step) ?
Intellisense is not working on the 'Transformer' Object, so I can't search for a property/object holding loaded data: [Dim objTransformer As Transformer = DirectCast(args.Inputs(0), Transformer)]
3 Replies
- franciscoamoresContributor II
Hi,
do you have access to GolfStream app? There are some examples in the event handler that shows how to query the Transformer Cache, update values...
Regards
- Keyser_SozeContributor
So you confirm that it is stored in memory not in an intermediate table ?
- franciscoamoresContributor II
Related Content
- 2 years ago
- 2 years ago
- 1 year ago