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
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
Differences between connected and unconnected lookup?
Which means the first record should come as last record and last record should come as first record and load into the target file?
what is INFORMATICA TESTING process
What are the different clients of powercenter?
How to load the data from people soft hrm to people soft erm using informatica?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
what is unit testing?tell me proceedure
Enlist some properties of sessions.
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What is rank transformation?
What is depict expression change?
What are the tuning techniques you applied during your last project
When do you use sql override in a lookup transformation?
Define pmcmd command?