176 lines
4.1 KiB
Plaintext
176 lines
4.1 KiB
Plaintext
table Dim_Original_Col_AIA
|
|
lineageTag: 10007bd6-7a54-472a-a9a2-6945502e4804
|
|
|
|
column PACK_COD
|
|
dataType: string
|
|
lineageTag: 9b37b7dc-6b84-472e-9fde-ce27bd739908
|
|
summarizeBy: none
|
|
sourceColumn: PACK_COD
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column DATA_SOURCE
|
|
dataType: string
|
|
lineageTag: 2f3635e3-2c32-42fe-ba01-565e20b04bf3
|
|
summarizeBy: none
|
|
sourceColumn: DATA_SOURCE
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column ATC1
|
|
dataType: string
|
|
lineageTag: 0b497f96-c256-453e-a981-f23b3181dec1
|
|
summarizeBy: none
|
|
sourceColumn: ATC1
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column ATC2
|
|
dataType: string
|
|
lineageTag: 73ac02c3-3726-4d50-86dd-2e5d98310f9c
|
|
summarizeBy: none
|
|
sourceColumn: ATC2
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column ATC3
|
|
dataType: string
|
|
lineageTag: 77203747-dd6f-47ad-af34-1171b85949c9
|
|
summarizeBy: none
|
|
sourceColumn: ATC3
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column ATC4
|
|
dataType: string
|
|
lineageTag: 3f99d6ad-f2a1-44a4-b854-138e4f2661ad
|
|
summarizeBy: none
|
|
sourceColumn: ATC4
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column org_prd_cd
|
|
dataType: string
|
|
lineageTag: ea0f3cce-57dd-4d6d-b22f-2fd03ebc68ba
|
|
summarizeBy: none
|
|
sourceColumn: org_prd_cd
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column org_mole_nm_c
|
|
dataType: string
|
|
lineageTag: 90d2ad6a-314b-4527-86a5-a6f18fd1ffbd
|
|
summarizeBy: none
|
|
sourceColumn: org_mole_nm_c
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column org_manu_prd_nm_c
|
|
dataType: string
|
|
lineageTag: 827221d3-e825-4620-9846-8fc64cbc5d73
|
|
summarizeBy: none
|
|
sourceColumn: org_manu_prd_nm_c
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column org_prd_nm_c
|
|
dataType: string
|
|
lineageTag: 5a67b69a-e485-450c-8849-8baa1c9af57f
|
|
summarizeBy: none
|
|
sourceColumn: org_prd_nm_c
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column org_pk
|
|
dataType: string
|
|
lineageTag: 3940ddff-b49f-4799-a585-302eb80b5dbf
|
|
summarizeBy: none
|
|
sourceColumn: org_pk
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column org_prd_str
|
|
dataType: string
|
|
lineageTag: d8935814-aa88-4894-b574-355972a85488
|
|
summarizeBy: none
|
|
sourceColumn: org_prd_str
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column org_pth
|
|
dataType: string
|
|
lineageTag: bf06afdc-ae92-4a2a-9e6f-8ec369f0f188
|
|
summarizeBy: none
|
|
sourceColumn: org_pth
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column min_pk_unit
|
|
dataType: string
|
|
lineageTag: e1126e1f-e911-4f6e-9ca9-1878b85154ba
|
|
summarizeBy: none
|
|
sourceColumn: min_pk_unit
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column org_pk_unit
|
|
dataType: string
|
|
lineageTag: a3bc3010-dc9e-4f9b-a7c2-e8c40b3d2722
|
|
summarizeBy: none
|
|
sourceColumn: org_pk_unit
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column org_manu_nm
|
|
dataType: string
|
|
lineageTag: 975eb300-f50c-4938-91dd-a872693ce429
|
|
summarizeBy: none
|
|
sourceColumn: org_manu_nm
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column PACK_SOURCE = ```
|
|
[PACK_COD] & [DATA_SOURCE]
|
|
```
|
|
lineageTag: e9af8c18-8173-4ec0-8c97-b19ca8df7822
|
|
summarizeBy: none
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
partition Dim_Original_Col_AIA = m
|
|
mode: import
|
|
queryGroup: 'OLD\AIA 独有表'
|
|
source = ```
|
|
let
|
|
Source =
|
|
Value.NativeQuery(
|
|
Databricks.Catalogs(
|
|
ServerAddress, HttpPath, [
|
|
Catalog = CatalogName,
|
|
Database = null,
|
|
EnableAutomaticProxyDiscovery = null,EnableQueryResultDownload="0"
|
|
]
|
|
){
|
|
[Name = CatalogName, Kind = "Database"]
|
|
}[Data],
|
|
"
|
|
SELECT PACK_COD, DATA_SOURCE, ATC1, ATC2, ATC3, ATC4, org_prd_cd, org_mole_nm_c, org_manu_prd_nm_c, org_prd_nm_c, org_pk, org_prd_str, org_pth, min_pk_unit, org_pk_unit, org_manu_nm
|
|
FROM DM.dm_td_aia_original_col
|
|
"
|
|
& UsingLimit,
|
|
null,
|
|
[
|
|
EnableFolding = true
|
|
]
|
|
)
|
|
in
|
|
Source
|
|
```
|
|
|
|
annotation PBI_ResultType = Table
|
|
|
|
annotation PBI_NavigationStepName = Navigation
|
|
|
|
annotation TabularEditor_TableGroup = 04_DimTable
|
|
|