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
------------------------------------------------------------

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

Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.

1 Answers   Accenture,

---

Why use shortcuts(Instead of making copies).

1 Answers  

---

What is flashback table ? Advance thanks

0 Answers   Puma,

---

who is the best faculty for informatica in hyderabad ameerpet?

1 Answers  

---

How do you load first and last records into target table?

0 Answers  

---

One flatefile it contains some data but i want to dont want to load first and last record ..how it is? can u tell me complete logic?

2 Answers  

---

What are the steps involved in the migration from older version to newer version of Informatica Server?

0 Answers  

---

How the dimensions will be loaded?

0 Answers   HCL,

---

How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this

9 Answers   Deloitte,

---

what is mean by complex business rule ?

0 Answers   Cap Gemini,

---

How can you display only hidden files in UNIX

4 Answers   Cognizant, L&T,

---

What is the need of an ETL tool?

0 Answers   Informatica,

---