| name | value |
|---|---|
| name | FactCurrencyRate |
| data source view | AdventureWorksDW |
| case sensitive | False |
| display expression | |
| friendly name | FactCurrencyRate |
| db schema name | dbo |
| db table name | FactCurrencyRate |
| type | Table |
| name | nulls | caption | data type | ordinal | unique | auto increment | auto increment seed | auto increment step | datetime mode | max length | is logical | db column name | computed column expression |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CurrencyKey | False | CurrencyKey | Int32 | 0 | False | ||||||||
| TimeKey | False | TimeKey | Int32 | 1 | False | ||||||||
| AverageRate | False | AverageRate | Double | 2 | False | ||||||||
| EndOfDayRate | False | EndOfDayRate | Double | 3 | False |
| parent column | child column | relation name | nested |
|---|---|---|---|
| DimCurrency. | FactCurrencyRate. | FK_FactCurrencyRate_CurrencyKey | False |
| DimTime. | FactCurrencyRate. | FK_FactCurrencyRate_TimeKey | False |
| name | object type | level |
|---|---|---|
| AdventureWorksDW | DataSourceView | 1 |
| AmoAdventureWorks | Database | 2 |