hi guys..iam a QA person ..what is ETL TESTING... what is the process of ETL testing... ETLTESTER needs etl devolopment knowledge or not? pls suggest ur valuable decision
- 2 Answers
- 7982 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / megha bagaria
Hi,
ETL testing is where you verify if your source data is correctly extracted, transformed and finally loaded into the target database or not. You need to verify at each level if your source data is matching with the target.
Process for ETL testing is you first identify your source tables or raw tables where data is present. Then check for the transformation logic if correctly implemented to load the data into target. Now verify your target DB which will have the transformed data of the source. you need to verify the correctness of data in the target DB like null values are not loaded, any data types is mis-matched, values are correct, garbage value is not stored, etc.
ETL tester needs the knowledge on the ETL development otherwise he will not be able to understand the requirement completely.
Please let me know if you need any more information.
Thanks and Best regards,
------------------------------------------------------------
Megha Bagaria | InfoCepts Technologies Pvt Ltd
------------------------------------------------------------
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / raju sharma
Hello Brother,
The ETL indicates Extract-->Transfer-->Load. You need to
know the data transaction between the source to target via
ETL . There are diffrent tools which are meant for ETL are
avialable in market like Abinitio,Informatic or like
Datastage etc. When in all the tool the common is
processing of data from source to target. You need to
understand the flow and mainly with the performance. Since
all the tools are measured based on thier performance of
loading the data. Beside to this you should also hold the
knowledge of Unix & DB. Becasuse the file level validation
requires unix more frequently.
Basic understanding of the ETL tool is enough for the
tester to proceed with thier test.Altogether an Tester can
become developer and in most companies they are preffered
too since tester have indepth knowldege of Functional part
as well the code.
With Best Regards
Raju Sharma
IT Analyst
SME : Abinitio , Informatica ,Datastage
| Is This Answer Correct ? | 1 Yes | 1 No |
What is update strategy transform?
How to prepared lld.can any one tell me detailed explanetion.
While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?
can u apply SCD2 on flat file tgt? if yes wat is the procedure?
Sequence generator, when you move from develoment to production how will you reset
What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?
I have been working in Informix-4gl for the past 2 years in an MNC company.But I'm interested to work in Business Intelligence tools. Is it possible to change the technology now? I'm really confused, please help me
If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING.. CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?
What are the tasks that Loadmanger process will do?
hi all when i am creating repository contents i am getting this error and not able to create contents please let me know wht may be the problem ORA-01031: insufficient privileges Database driver error... Function Name : executeDirect SQL Stmt : CREATE VIEW REP_DATABASE_DEFS AS SELECT DISTINCT DBDNAM DATABASE_NAME, SRCNAM DEF_SOURCE, SUBJ_NAME SUBJECT_AREA, NULL VERSION_ID, OPB_DBD.VERSION_NUMBER DATABASE_VERSION_NUMBER FROM OPB_DBD, OPB_SUBJECT, OPB_SRC WHERE OPB_DBD.SUBJ_ID = OPB_SUBJECT.SUBJ_ID AND OPB_SRC.DBDID = OPB_DBD.DBDID AND OPB_SRC.VERSION_NUMBER = OPB_DBD.VERSION_NUMBER AND OPB_SRC.IS_VISIBLE = 1 Oracle Fatal Error Database driver error... Function Name : ExecuteDirect Oracle Fatal Error Error occurred while creating the repository An error has occurred while creating contents. Dropping repository tables... Create Contents operation on repository [reposerv] ended at 01/02/2009 13:02:48. Elapsed time is 0:00:09.
Teradata 
