how do u implement configuration management in Informatica?
Explain the difference between etl tool and olap tools?
how do u extract data from different data sources explain with an example?
What are the three tiers in etl?
if i have a query as flat file how can we load data to target table
What is the difference between Data Warehousing and Data Mining?
What is partitioning? Explain different types of partitioning?
Define slowly changing dimensions (SCD)?
Explain about enterprise scalability and roi of data integration suite?
What is the difference between round-robin partitioning and hash partitioning?
Explain etl mapping sheets?
What are the modules in Power Mart?
What are dimensions?
where we cannot use sorter Transformation. if we use then we will not get correct data?
What are the different etl testing categories as per their function?