ETL - What are the various test procedures used to check whether the data is loaded in the backend, perfor

GeekInterview.com > Interview Questions > Data Warehousing > ETL

Go To First | Previous Question | Next Question

ETL | Question 33 of 64

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.

Total Answers and Comments: 3

Last Update: May 12, 2008 Asked by: Andy

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

May 06, 2006 00:19:31

shaik

RE: What are the various test procedures used to check...

The best procedure to take a help of debugger where we monitor each and every process of mappings and how data is loading based on conditions breaks.

Is this answer useful? Yes | No

November 09, 2006 06:16:33

Anil

RE: What are the various test procedures used to check...

Hi, u can check out the session logfiles for the total number of records added number of records udated and number of rejected records and errors related to that so this is the answer the interviewer is expecting from usk

Is this answer useful? Yes | No

May 12, 2008 09:31:01

njvijay

Member Since: May 2007 Contribution: 10

RE: 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.

Need to have reconciliation strategy to very input and output data with reject counts

Is this answer useful? Yes | No

Go To Top