Technical 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
IN INFORMATICA TO REMOVE DUPLICATE RECORDS BY USING
FIRST WAY IS
USING SOURCE QUALIFIER TRANSFORMATION CLICK ON PROPERTIES AND SELECT DISTINCT PROPERTY THEN YOU WILL REMOVE DUPLICATE RECORDS.
BY USING SOURCE QUALIFIER YOU CAN OVERRIDE THE SQL QUERY YOU CAN REMOVE DUPLICATE RECORDS BUT IT IS WORKING ONLY FOR DATA BASE SOURCE NOT WORKING FOR FLAT FILES.
SECOND WAY:
IN SORTER TRANSFORMATION ALSO YOU CAN CLICK ON PROPERTIES TAB SELECT DISTINCT PROPERTY THIS SCENARIO ALSO WORKING TO REMOVE DUPLICATE RECORDS.
THIRD WAY:
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!