1)What are the various test procedures used to check whether the data is loaded in the back end, performance of the mapping, and quality of the data loaded in INFORMATICA. 2) What are the common problems developers face while ETL development
RE: 1)What are the various test procedures used to check whether the data is loaded in the back end, performance of the mapping, and quality of the data loaded in INFORMATICA.
To check data loaded in the backend can be done by collecting the session results from the reposistory tables quality of dataloaded can be done by writing sql qureries on the target table.
To Check performance of the mapping
Enable collect performance data in edit task properties and check the performance log after session run is completed
In Workflow monitor right link on session --> Properties---> Transformation statistics.
