In this Informatica interview questions list, you will come to know the top questions asked in the Informatica job interview. You will learn the difference between a database and a data warehouse, Informatica Workflow Manager, mapping parameter vs mapping variable, and more. Learn Informatica from Intellipaat Informatica Certification Course and fast-track your career!
Performance Tuning & Best Practices in Informatica – In depth Knowledge part 1
40. What are the features of complex mapping?
The features of complex mapping are as follows:
72. Name the other tools used for scheduling purpose other than Workflow Manager and pmcmd.
‘CONTROL M’ is a third-party tool used for scheduling purposes.
10. How can we update a record in the target table without using Update Strategy?
A target table can be updated without using ‘Update Strategy.’ For this, we need to define the key in the target table at the Informatica level, and then we need to connect the key and the field we want to update in the mapping target. At the session level, we should set the target property as ‘Update as Update’ and check the ‘Update’ check box.
Let us assume, we have a target table ‘Customer’ with fields as ‘Customer ID,’ ‘Customer Name,’ and ‘Customer Address.’ Suppose if we want to update ‘Customer Address’ without an Update Strategy, then we have to define ‘Customer ID’ as the primary key at the Informatica level, and we will have to connect ‘Customer ID’ and ‘Customer Address’ fields in the mapping. If the session properties are set correctly as described above, then the mapping will only update the ‘Customer Address’ field for all matching customer IDs.
CTA
FAQ
What are the performance tuning techniques in Informatica?
- Optimize the target. …
- Optimize the source. …
- Optimize the mapping. …
- Optimize the transformation. …
- Optimize the session. …
- Optimize the grid deployments. …
- Optimize the PowerCenter components. …
- Optimize the system.
What is performance bottleneck in Informatica?
How does Informatica improve lookup performance?
- Use the optimal database driver.
- Cache lookup tables.
- Optimize the lookup condition.
- Filter lookup rows.
- Index the lookup table.
- Optimize multiple lookups.
How can we improve the performance of joiner transformation in Informatica?
- Designate the master source as the source with fewer duplicate key values. …
- Designate the master source as the source with fewer rows. …
- Perform joins in a database when possible. …
- Join sorted data when possible.
