Project and packages - after data view is refreshed

[ry1633]

Hi guys,

This might be a simple question but I'm not sure what to do.  I already made a project and package in Framework Manager.   But my DBA and I were talking through some stuff and he made some slight changes.   How can I refresh my project and will it negatively affect any packages I've made?

[cognostechie]

Depends on what changes were made. If a field has been added, it can be added easily by 'Update Object' option.

[Michael75]

Hi ry1633,

The following reply supposes that:
- you know which tables / views have been changed by your DBA
- that you have modelled using FM best practices, which include a "DB Layer" or "Import Layer", in which the definition of each Query Subject only contains

Code Select Expand

select * from <schema.table>

If that's the case, in FM you should, one by one, click on the affected table / view, then do a Tools > Update Object. This will refresh the definition of the table / view in this FM Layer. If columns have been deleted in the DB, you'll now receive some serious warnings about the repercussions in the downstream layers of the FM project. What you do here is up to your discretion, but it's really a question of common sense and knowledge of the data. Basically, you have to align your other layers on the reality of the new DB Layer, be it deleted / renamed / inserted columns.

Rgds, Michael