OLE_SRC Existing DimRelativeDay Dimension - Component

Properties

Property	Value
Name	OLE_SRC Existing DimRelativeDay Dimension
Description	OLE DB Source
Up Stream Components	none
Down Stream Components	TF Dimension Merge Slowly Changing Dimension RelativeDay
ID	323
Component Class ID	{BCEFE59B-6819-47F7-A125-63753B33ABB7}
Contact Info	OLE DB Source;Microsoft Corporation; Microsoft SqlServer v10; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;7
Identification String	component "OLE_SRC Existing DimRelativeDay Dimension" (323)
Is Default Locale	True
Pipeline Version	0
Uses Dispositions	True
Validate External Metadata	True
Version	7

Connections

Name	Connection Manager	Description
OleDbConnection	EnterpriseDW

Custom Properties

Name	Value
AccessMode	2
AlwaysUseDefaultCodePage	False
CommandTimeout	0
DefaultCodePage	1252
OpenRowset
OpenRowsetVariable
ParameterMapping
SqlCommand	SELECT [RelativeDaySK] ,[Term] ,[TermYear] ,[TermTypeCode] ,[TermTitle] ,[RelativeDayNumber] ,[RelativeDay] ,[RelativeDayDate] ,[RelativeDayDateSK] ,[RowIsCurrent] ,[RowStartDate] ,[RowEndDate] FROM [dbo].[DimRelativeDay] WHERE RowIsCurrent = 'Y' ORDER BY Term , RelativeDayNumber
SqlCommandVariable

Input Columns

Name

ID

LineageID

Output Columns

Name	ID	LineageID
ErrorCode	335	335
ErrorColumn	336	336
RelativeDay	1542	1542
RelativeDayDate	1545	1545
RelativeDayDateSK	1548	1548
RelativeDayNumber	1539	1539
RelativeDaySK	1524	1524
RowEndDate	1557	1557
RowIsCurrent	1551	1551
RowStartDate	1554	1554
Term	1527	1527
TermTitle	1536	1536
TermTypeCode	1533	1533
TermYear	1530	1530
RelativeDay	1541	1541
RelativeDayDate	1544	1544
RelativeDayDateSK	1547	1547
RelativeDayNumber	1538	1538
RelativeDaySK	1523	1523
RowEndDate	1556	1556
RowIsCurrent	1550	1550
RowStartDate	1553	1553
Term	1526	1526
TermTitle	1535	1535
TermTypeCode	1532	1532
TermYear	1529	1529

Powered by BI Documenter