⟩ What are vaious ETL tools in the Market?
Various ETL tools used in market are:
1. Informatica
2. Data Stage
3. MS-SQL DTS(Integrated Services 2005)
4. Abinitio
5. SQL Loader
6. Sunopsis
7. Oracle Warehouse Bulider
8. Data Junction
Various ETL tools used in market are:
1. Informatica
2. Data Stage
3. MS-SQL DTS(Integrated Services 2005)
4. Abinitio
5. SQL Loader
6. Sunopsis
7. Oracle Warehouse Bulider
8. Data Junction
What is Session and Batches?
Explain What is the limit to the number of sources and targets you can have in a mapping?
Explain What are the tasks that Loadmanger process will do?
Explain What is batch and describe about types of batches?
How to do unit testing in informatica? How to load data in informatica ?
Explain What are the mapping paramaters and maping variables?
Why we use repository connectivity?
Explain the Differences between Normalizer and Normalizer transformation?
How to handle decimal places while importing a flatfile into informatica?
What is the difference between Informatica 7.0 and 8.0?