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
- 9107 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
What do you understand by term role-playing dimension?
How to go to the older version for a mapping?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
How we can create indexes after completing the loan process?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What is rank transformation in informatica
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
How can we create index after completion of load process?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is source qualifier transformation in informatica?
What is a rank transform?
Define joiner transformation?
