This content has been marked as final. Show 3 replies
Did you check this doc for ETL/DAC?
Since you want to point W_MCAL_DAY_D instead of W_DAY_D I would suggest to extract the existing logical table into udml and replace the source table and apply back the udml to rpd.
that would be easiest way to do.
If helps mark
Edited by: Srini VEERAVALLI on Feb 11, 2013 9:11 AM
If I replace W_DAY_D with W_MCAL_DAY_D in UDML, what about the corresponding column replacement/mapping?
I have figured out a way, Need to join facts date_wid with MCAL_DAY_DT_WID of W_MCAL_DAY_D instead of ROW_WID of W_DAT_D and need to expose MCAL cols...
Yes, You have to use MCAL instead of DAY.
After your join in Physical layer, identify the logical table for DAY in BMM duplicate it change the source DAY to MCAL and then remap each column from DAY to MCAL.
Since you might need same logical column names re-mapping would be easiest one.
UDML might take something instead of that above said method would be easier.