Archives of the TeradataForum
Message Posted: Thu, 30 Oct 2014 @ 10:11:55 GMT
We are planning to move from deformalized warehouse to Fact and Dimensional warehouse. What are all those prerequisites require for the same?
For example ,We have source system like ERP, and they are sending us Transactional data from Orders, Account Receivable, General Ledger. Also we are getting Lookup data from source system like Country, Currency etc.
Can anyone provide a sample/example? What should be the INDEX in Dimension and Fact table?
Thanks in advance.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|