⟩ Explain some of modeling tools available in the Market?
These tools are used for Data/dimension modeling
1. Oracle Designer
2. ERWin (Entity Relationship for windows)
3. Informatica (Cubes/Dimensions)
4. Embarcadero
5. Power Designer Sybase
These tools are used for Data/dimension modeling
1. Oracle Designer
2. ERWin (Entity Relationship for windows)
3. Informatica (Cubes/Dimensions)
4. Embarcadero
5. Power Designer Sybase
Explain What is metadata reporter?
What are the unsupported repository objects for a mapplet?
How can we transform row to column?
What is a time dimension? give an example?
Explain Why dimenstion tables are denormalized in nature?
How to eliminate duplicate rows from flat file?
How to load the data from people soft hrm to people soft erm using informatica?
Explain How to export mappings to the production environment?
How Identifying bottlenecks in various components of Informatica and resolving them?
What is Recovering sessions?