Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9045 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Differentiate between sessions and batches?
How can we use mapping variables in informatica? Where do we use them?
What are mapplets? How is it different from a Reusable Transformation?
How can repository reports be accessed without sql or other transformations?
Define update strategy?
What do you mean by filter transformation?
How to generate sequence numbers using expression transformation?
What is the need of an ETL tool?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What is union transformation in informatica?
Describe an informatica powercenter?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What are the new features of informatica 9.x in developer level?
r u done any partitions in ur project?
What is the maplet?
