Login
Remember
Register
Ask a Question
What is the way to find all the invalid mappings in a folder?
0
votes
asked
Jun 6, 2021
in
Informatica
by
rajeshsharma
What is the way to find all the invalid mappings in a folder?
invalid-mapping
mapping-folder
mapping-informatica
Please
log in
or
register
to answer this question.
1
Answer
0
votes
answered
Jun 6, 2021
by
rajeshsharma
By using a query all the invalid mappings in a folder can be found. It is:
SELECT MAPPING_NAME FROM REP_ALL_MAPPINGS WHERE
SUBJECT_AREA='YOUR_FOLDER_NAME' AND PARENT_MAPPING_IS_VALIED <>1
...
