Calculated field on a fact table

[Ameyy]

I want to calculate age based on current date and load that into fact table. However my fact is not truncate and reload. It is incremental. In Tmap i cannot do that as it will try to insert daily based on change in current date. Is global variable my only option?

[Anonymous]

Hi

Can you describe your case with some example data? What are your expected result?

Regards

Shong