The question is the last part . The fact table needs to updated with the news ids.

Please see the last table. That is the result form I need it in.