Welcome To Informatica Tutorials

Informatica Tutorials website is dedicated to all our students, who are beginners and also industry experts who have achieved heights in their careers in wide domains areas like banking, investment banking, retail, manufacturing, pharma, insurance and reinsurance etc

We are thankful to our students for having trust in us especially to all those students, who are now industry experts, who keep coming back to us to refresh and rejuvenate their knowledge and skills in Informatica tool sets as industry demands them time and time again, and also due to the changes or upgrades in technology and Informatica Tool sets.

Finally we are very very thankful to all our staff members who are around the planet who are working in their professions and who keep contributing to our knowledge base and training materials up to industry standards. They also keep investing in training themselves and keep sharing their knowledge and expertise to our students all the time. With out their contribution this Informatica tutorials, training and mentorship would not exist.

We thank you all for your continued support

Informatica Tutorial Team

 

 

“TE_7020 Unbound field in Source Qualifier” when running session

Problem Description

TE_7020 Unbound field in Source Qualifier

Informatica Error – TE_7020 Unbound field in Source Qualifier

When running a session the session fails with the following error:

“TE_7020 Unbound field in Source Qualifier”

Solution
This error will occur when there is an inconsistency between the Source Qualifier and the source table.
Either there is a field in the Source Qualifier that is not in the physical table or there is a column of the source object that has no link to the corresponding port in the Source Qualifier.

  1. To resolve this, re-import the source definition into the Source Analyzer in Designer.
  2. Bring the new Source definition into the mapping.
    This will also re-create the Source Qualifier.
  3. Connect the new Source Qualifier to the rest of the mapping as before.