Last Updated:
June 17, 2021
by
Jesse Langstaff
| Version: 10
| 1,396 views
| 0 followers
members are following updates on this item.
Dimension tables (tables that begin with "d") contain general information about Igloo Objects. Within a table, an object may have many rows associated with it. This happens because actions such as archiving or renaming create new rows in the table. While the object will receive a new row and unique key value, its Source System ID will remain the same.
As a result:
The dUser table contains Users who have ever performed any action in your digital workplace. To identify current members of your digital workplace you will need to identify what users are currently in the Member group.
Tables such as fact tables (tables that being with "f") can get very large. Filter this data by a specific date range. Also, remove any unneeded columns.
Identify Guest Users in fact tables by their user_key value 367003. Activity by Guest Users is most common on locations that have been made open to the public.