1)What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in INFORMATICA.2) What are the common problems developers face while ETL development

Showing Answers 1 - 5 of 5 Answers

Bhanu Jamwal

  • May 12th, 2006
 

Some of the steps could be :

1) Check in  the workflow monitor status, whether no. of records in source and no. of actual records loaded are equal

2) Check for the duration for a workflow to suceed

3)Check in the session logs for data loaded.

  Was this answer useful?  Yes

Prasad

  • Jul 14th, 2006
 

Hi,

If you want to know the performance of a mapping at transformation level, then select the option in the session properties-> collect performance data. At the run time in the monitor you can see it in the performance tab or you can get it from a file.

The PowerCenter Server names the file session_name.perf, and stores it in the same directory as the session log. If there is no session-specific directory for the session log, the PowerCenter Server saves the file in the default log files directory.

Quality of the data loaded depends on the quality of data in the source. If cleansing is required then have to perform some data cleansing operations in informatica. Final data will always be clean if followed.

  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