Hi all,
I've recently joined a company as a BI consultant and I've been tasked with adding the data field ID/KEY from the "USER_DATA_CUST_DIM_2" table into the "AG2_QUEUE*" tables.
[b]
Dimension table & ID (PK):[/b] [u]USER_DATA_CUST_DIM_2.ID[/u]
[b]Fact (Aggregate) table name:[/b] [u]AG2_QUEUE_HOUR[/u] --- [i]Does not contain the foreign key for the 'USER_DATA_CUST_DIM_2' table[/i]
What I am simply trying to do is enable to flow of data (key field) from this dimension table into the above AG2 / fact table. And if I look at some other tables e.g. AG2_AGENT_QUEUE* I can see that this relationship is mapped and that the foreign key to this dimesion is exists in the table e.g. AG2_AGENT_QUEUE_HOUR.CUSTOM_KEY_2=USER_DATA_CUST_DIM_2.ID.
As I'm used to different / more popular ETL tools where I can simply modify SQL / mappings within stored procs, I'm not at all sure how to do this in the packaged GIM solution. As I'm completely new to this, is anyone out there able to advise how this could be achieved??
My understanding is that a lot of the ETL logic might be held in pre-packaged scripts / configurations held somewhere....
It seems like a very simple ETL change, yet is proving very difficult to find any documentation or instruction on how to do this.
Thanks in advance!
Kelvin
--------------------------
System details here...
Informart Version: 8.1.400.12
DBMS: Oracle 11g
