Requirement to add a new column in W_PARTY_ORG_D which is slowly changing dimension in ODI
--------------------------------------------------------------------------------------------------------
Models-->W_PARTY_ORG_D_>RIGHT CLICK OPEN_>COLUMNS->NEW COLUMN
After adding the column in table.Expand the table W_PARTY_ORG_D->Columns-->select the new column->rightclick open->Description-->Slowly Changing behaviour->we should select any one of it from the selection list(overwrite onchange,etc..).Then only data will be loaded for new column other wise new column will not be selected in select clause while executing the interface in ODI.
--------------------------------------------------------------------------------------------------------
Models-->W_PARTY_ORG_D_>RIGHT CLICK OPEN_>COLUMNS->NEW COLUMN
After adding the column in table.Expand the table W_PARTY_ORG_D->Columns-->select the new column->rightclick open->Description-->Slowly Changing behaviour->we should select any one of it from the selection list(overwrite onchange,etc..).Then only data will be loaded for new column other wise new column will not be selected in select clause while executing the interface in ODI.
No comments:
Post a Comment