To all the ODI experts,
If I have 2 fact tables joined into a logical fact, can ODI be used to extract (make a dump) on the data into another database table? I heard there's knowledge modules but I don't know how far it can go.
Thanks a million for any advice.
You could potential define an ODBC source pointing to your BI-Server and use ODI against that ODBC source, but you should probably would want to mimic the logic of the your BMM-Layer Fact-Table-LTS in some normal ODI interface.