What are features of Informatica Repository Server? - ETL

ETL (extract, transform, and load) Testing Interview Questions

(Continued from previous question...)

70. What are features of Informatica Repository Server? - ETL

Features of Informatica Repository Server.
1. Informatica client application and Informatica server access the repository database tables through the Repository Server.
2. Informatica client connects to the repository server through the host name/ IP address and its port number.
3. The Repository Server can manager multiple repository on different machines on the network.
4. For each repository database registered with the Repository Server it configures and manages a Repository Agent process.
5. The Repository Agent is a multi-threaded process that performs the action needed to retrieve, insert and updated metadata in the repository database tables..

(Continued on next question...)

Other Interview Questions

• Why we use lookup transformation? - ETL
• What are the different sources of Source systems of Data Warehouse? - ETL
• What are Cubes? - ETL
• Advanced ETL Interview Questions - I have ten records in my source system but I need to load only 2 records to the target for each run. How do I do this?
• What is Snow Flake schema Design? - ETL
• How DTM buffer size and buffer block size are related? - ETL
• What does a Mapping document contains? - ETL
• Difference between Database and Data Warehouse Testing - ETL
• What is Full load & Incremental or Refresh load?
• What are Dimensions? - ETL
• More...