What are the challenges of ETL Testing ?
https://www.zyxware.com/sites/default/files/styles/user_image/public/default_images/index.png?itok=2YmREnrP
BY anoop.v
4 years ago
Quality-Assurance
1 comments comment

ETL or Data warehouse testing is quite different with regular testing. There are lot of challenges are facing while performing ETL or Data warehouse testing. Do you need a testing expert or want help in your business, just click here to hear from us.

The main challenges of ETL or Data warehouse testing includes :

  • Data loss during ETL testing.
  • Duplicate data and Incompatibility.
  • Lack of inclusive test bed.
  • Testers have no benefits to execute ETL jobs by their own.
  • Data volume and complexity is huge.
  • Inefficient in procedures and business process.
  • Inconvenience securing and building test data.
  • Absence of business course information.

Data plays a very important role in business to make business decisions. ETL testing plays a notable role in reliability, consistent and validation process. For more information, click here


RELATED ARTICLE

/themes/custom/zyxpro_light/images/placeholder.png
close

on 31st August 2012 / by minu.podipara
Banking application packages are probably the most complex software suites which demand high secu Quality Assurance Testing Test Cases Data Field Leave a reply Your email address will not be published. Required fields are marked * Anonymous (not verified) access_time 24 May 2020 - 21:07 In User Acceptance Testing u said that End-users will done? How actually it goes? Add new comment
/themes/custom/zyxpro_light/images/placeholder.png
close

on 19th October 2012 / by lijo.abraham
As per the as per Kerala Municipal Act, 1994 (Section 254) it is mandatory for all employees who are drawing a half yearly salary of more than Rs. 12,000/- to pay profession tax. This tax is to be paid to the respective corporation/ municipality in which the company is situated. The tax slab is as mentioned in the below table. Quality Assurance Testing Checklist Test Case Search Field Leave a reply Your email address will not be published. Required fields are marked * Gopkumar (not verified) access_time 24 May 2020 - 21:07 I am starting a small firm in Panchayat / Municipal area of Trivandrum (Kerala). While keeping myself abreast of statutory regulations, I could see that Professional Tax of every employee as per their status of salary is to be collected from every employee and remitted to the concerned Panchayat or Municipality. Now I am told that in addition to the tax collected from every employee, my organization also has to pay Tax. Is it true ? I could not see this in the Rules. Can you please guide me ? Joby.P.K (not verified) access_time 24 May 2020 - 21:07 My friend is getting an amount of Rs. 12000/- as monthly honorarium continuously from a government office. Hence it may be clarified that whether he is liable to remit profession tax since he is receiving payment as honorarium. The matter may kindly be clarified along with a copy of Govt. Order if possible. JOSEPH (not verified) access_time 24 May 2020 - 21:07 We got a notice from thrikkakara municipality for institution tax for employment. please tell the provisions of kerala municipal act about institutions tax laibility for employment. Adarshmv86 (not verified) access_time 24 May 2020 - 21:07 Hi sir, am working in as HR execuite in a pvt firm regd under kerala shops ans commercial establishment. I want to know that if there is any process of registraion for payment of PT in to muncipality. sheelamichayel (not verified) access_time 24 May 2020 - 21:07 In reply to Professional tax by Adarshmv86 (not verified) I want to know in favour of whom the PT cheque shoule be made. Add new comment
/themes/custom/zyxpro_light/images/placeholder.png
close

on 02nd November 2012 / by renjith
While testing any website, be it Drupal / non-Drupal, one would often have to test Date fields. Following are the test cases to be considered / checked for, while testing a date field: Quality Assurance Testing Test Cases Data Field Leave a reply Your email address will not be published. Required fields are marked *
Leave a reply
Your email address will not be published. Required fields are marked *

Filtered HTML

  • Web page addresses and email addresses turn into links automatically.
  • Allowed HTML tags: <a href hreflang> <em> <strong> <cite> <blockquote cite> <code> <ul type> <ol start type='1 A I'> <li> <dl> <dt> <dd> <h2 id='jump-*'> <h3 id> <h4 id> <h5 id> <h6 id>
  • Lines and paragraphs break automatically.
The content of this field is kept private and will not be shown publicly.
CAPTCHA This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.

author-image
anjani (not verified)
access_time 25 May 2020 - 01:26

Target is EDWSMDM
Destination is Fact Loe_Bd_customers1
staging = get all leads associated with campaigns that have upplier-di=12004

In thi scenario,how can i identify what is the source and the target
and how to writ the SQL query for this,iam new to etl testing,and very confused.
please advise,help