Technical Interview Questions and Answers :: Informatica
Home > Technical Interview Q&A > Informatica > Q & A
Accenture (161)
Adobe (2)
Alcatel-Lucent (1)
Broadcom Ltd (1)
Wipro (84)
Virtusa (220)
IBM (35)
Aricent (47)
Tech Mahindra (13)
TCS (170)
Capgemini (32)
iGate (162)
Syntel Inc. (175)
AT&T (1)
Cisco (107)
Sapient (72)
Sopra Steria (138)
Societe Generale (75)
Goldman Sachs (5)
TCS NQT (7)
Huawei (11)
Wipro NLTH (36)
# C (123)
# C++ (184)
# DBMS (143)
# Soft. Engineering (77)
# Python (2)
# Finite Automata (6)
# SQL (106)
# Java (66)
# .NET (112)
# WebMethod (166)
# EDI (40)
# Informatica (94)
# Oracle Apps HRMS (106)
# Operating System (89)
# Data Structure (66)
# PHP (1)
# Unica (0)
# Oracle Apex (0)
# HR Question in TR (122)
# Networking (61)
# Hadoop (2)
# HTML (1)
# Oracle PLSQL (31)
# DPDK (Data Plane Development Kit) (40)
- 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
|
|
|
Answer:
No Discussion on this question yet!
Please Login First :
62 / 94
|
|
|
Answer:
No Discussion on this question yet!
Please Login First :
63 / 94
|
|
|
Answer:
No Discussion on this question yet!
Please Login First :
64 / 94
|
|
|
Answer:
If the lookup table is on the same database as the source table in your mapping and caching is not feasible, join the tables in the source database rather than using a Lookup transformation.
If you use a Lookup transformation, perform the following tasks to increase performance:
Please Login First :
65 / 94
|
|
|
Answer:
No Discussion on this question yet!
Please Login First :
66 / 94
|
|
|
Answer:
No Discussion on this question yet!
Please Login First :
67 / 94
|
|
|
Answer:
No Discussion on this question yet!
Please Login First :
68 / 94
|
|
|
Answer:
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 |
Please Login First :
69 / 94
|
|
|
Answer:
No Discussion on this question yet!
Please Login First :
70 / 94
|
|
|
Answer:
No Discussion on this question yet!
Please Login First :