Login/RegisterTechnical Interview Questions and Answers :: Informatica
- Use the optimal database driver.
- Cache lookup tables.
- Optimize the lookup condition.
- Filter lookup rows.
- Index the lookup table.
- Optimize multiple lookups.
- Create a pipeline Lookup transformation and configure partitions in the pipeline that builds the lookup source.
- It uses only = operator to match column data.
- It has four type of joiner :
- Normal join
- master outer join
- detail outer join
- Full outer join
- It uses =,>=,<=, != operator.
- It work like Left outer join only.
61 / 94
The persistent cache in lookup transformation behaves as the cache is utilized again in the same workflow(mapping) execution on again and again.
The Integration Service saves or deletes lookup cache files after a successful session run based on whether the Lookup cache is checked as persistent or not.
62 / 94
No Discussion on this question yet!
63 / 94
No Discussion on this question yet!
64 / 94
65 / 94
No Discussion on this question yet!
66 / 94
No Discussion on this question yet!
67 / 94
No Discussion on this question yet!
68 / 94
Join Transformation | Lookup Transformation |
Joiner is active and connected transformation | Lookup is active/passive and connected or unconnected transformation. |
Joiner transformation is used to usually to join data coming from two separate tables or source qualifiers. | Look up transformation can be used on a single table or a query to search for records that match incoming Records |
69 / 94
No Discussion on this question yet!
70 / 94
No Discussion on this question yet!
