如何在informatica中对FlatFile目标进行SCD Typ1

ID,Name,Address,EffectiveDate,EndDate
1,John Doe,123 Main St,2020-01-01,
2,Jane Smith,456 Elm St,2020-01-01,

CREATE TABLE customer_dim (
    ID INT PRIMARY KEY,
    Name VARCHAR(100),
    Address VARCHAR(100),
    EffectiveDate DATE,
    EndDate DATE
);

<Mapping>
    <Source Qualifier="SRC_CUSTOMER">
        <SourceDefinition>Customer_Source</SourceDefinition>
    </Source>
    <Target LoadOrder="1" Name="TGT_CUSTOMER_DIM">
        <TargetDefinition>Customer_Dim</TargetDefinition>
    </Target>
    <Transformation Type="Expression" Name="EXP_SCD_TYPE1">
        <InputParameters>
            <InputParameter Expression="IIF(TARGET.EndDate IS NULL, TODAY(), TARGET.EndDate)" Name="EndDate" Type="DATE"/>
            <InputParameter Expression="SRC.EffectiveDate" Name="EffectiveDate" Type="DATE"/>
        </InputParameters>
        <OutputParameters>
            <OutputParameter Expression="SRC.ID" Name="ID" Type="INTEGER"/>
            <OutputParameter Expression="SRC.Name" Name="Name" Type="VARCHAR(100)"/>
            <OutputParameter Expression="SRC.Address" Name="Address" Type="VARCHAR(100)"/>
            <OutputParameter Expression="#Parameters.EndDate" Name="EndDate" Type="DATE"/>
            <OutputParameter Expression="#Parameters.EffectiveDate" Name="EffectiveDate" Type="DATE"/>
        </OutputParameters>
    </Transformation>
    <Joiner JoinType="Left" Name="JOINER_SCD">
        <Input>
            <JoinCondition>SRC.ID = TGT.ID</JoinCondition>
            <LeftInput>
                <RefEntity>SRC_CUSTOMER</RefEntity>
            </LeftInput>
            <RightInput>
                <RefEntity>TGT_CUSTOMER_DIM</RefEntity>
            </RightInput>
        </Input>
    </Joiner>
    <Expression Transformation="EXP_SCD_TYPE1">
        <Input>
            <RefEntity>JOINER_SCD</RefEntity>
        </Input>
        <Output>
            <RefEntity>TGT_CUSTOMER_DIM</RefEntity>
        </Output>
    </Expression>
</Mapping>