This content has been marked as final. Show 6 replies
You can add columns to the table in the module and synchronize with the OWB mapping table operator (inbound) - or the reverse (outbound). As for the count - it depends on the SQL you are trying to do - the aggregation operator lets you use aggregation functions such as COUNT/SUM etc
Thank you very much. Just one more clarification. I am going to use the joiner and then the aggregation operator and then connect them to the staging table. I need only two fields to be edited with the count expression.
Should I connect only these two attributes to the aggregation operator and the others straight to the stage table operator or I must connect them all through the aggregation operator?
Is there any affection to the rest of the data?
All columns need to go through the aggregator. For sure the data will change from what you have just now.
I' ve just realized that I am reading your book! Oracle Warehouse Builder 11gR2: Getting Started 2011.
What If I need the rest of the fields not to be changed? Fields like Name or whatever.I can't figure it out. Thanks again.
For example, I have these two fields Name and Date and I want to use the count expression through the aggregation operator for the Date field and create a new field Quantity to store the reaults. But I need the field Name to remain intact.
How can I manage this? Thank you.
Edited by: 928543 on 11 Ιαν 2013 1:35 μμ
Edited by: 928543 on 11 Ιαν 2013 1:44 μμ
You should check analytic functions:
I haven't found out how I can introduce an analytic function to the mapping canvas.
Is there any operator I should use? Thanks.