How can we use external procedural logic in informatica?
Do we need an etl tool?
What is etl process. How many steps etl contains explain with example?
What is a staging area? What is the purpose of a staging area?
What are vaious etl tools in the market?
What are the measure objects?
What are the different types of transformation available in informatica.
Explain what are the different types of transformation available in informatica.
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
How to do unit testing in informatica? How to load data in informatica ?
Explain the different dimensions.
Differentiate between source qualifier and filter transformation?
Explain scd type 3 through mapping.
What is dimensional table?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?