Multiple choice technology

Suppose you have imported table from database as a source and you have used that source in multiple mappings. If there is any change in the source table structure in the database then how will it be reflected in the mapping?

  1. the changes in the source table in the database will not be reflected in the source that has been imported

  2. N/A

  3. do the changes in the source table , close the session and then re-import the data

  4. NA

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

When you import a source table in Informatica, it creates a static definition of that table structure at the time of import. Changes made later in the actual database are not automatically reflected in the imported source definition or mappings that use it. You must manually re-import or synchronize the source definition to pick up database changes.