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

Questions by phanimv   answers by phanimv

Showing Answers 1 - 12 of 12 Answers

ajay

  • Jan 9th, 2007
 

hi

first u have to set collect performance data in properties of the session menu in workflow manager

run the session and go to workflow monitor right click on that particular workflow select properties,performance

  Was this answer useful?  Yes

tomtwj

  • Mar 14th, 2007
 

Performance, Data quality, consistensy and exception handling, large various source types.  

  Was this answer useful?  Yes

dl_mstr

  • Feb 10th, 2008
 

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

  1. Enable collect performance data in edit task properties and check the performance log after session run is completed
  2. In Workflow monitor right link on session --> Properties---> Transformation statistics.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions