Say a target having 10 columns might be having only 3 columns available in the source and hence only these 3 will be mapped in the target. Use the below query to know these connected column names.
In the below query give your folder name to SUBJECT_AREA and your mapping name to MAPPING_NAME.
SELECT TO_OBJECT_FIELD_NAME
FROM REP_MAPPING_CONN_PORTS
WHERE TO_OBJECT_TYPE=2
AND MAPPING_NAME ='M_STG_DATA_LOAD_FOR_TESTING'
AND SUBJECT_AREA='USR_KOTHAKOP'
This is nice article and very good explanation
ReplyDeleteInformatica training in bangalore,informatica online training,infroamtica dataquality training in bangalore, informatica tutorials, best informatica training in bangalore, best informatica online training in bangalore
Where we need to execute the query :-(
ReplyDeleteThis is Repository query. This needs to be executed in Repository database. Please ask your Infa admin to run the query incase if they do not provide you select access on repository database.
Delete