Answer Posted / koti

Re: How do you create single lookup transformation using
multiple tables?
Answer
# 1 Lookup transformation: Based upon one/more keys the
data is
retreived from one/more tables.

create a single lookup transformation by Joining the
multiple tables, having connected the keys defined in
lookup tranformation.

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1773

---

What are the different lookup cache(s)?

1113

---

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

2156

---

can anyone suggest best free Talend data integration training online

1689

---

Enlist few areas or real-time situations where informatica is required.

1073

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1950

---

What are the types of schemas we have in data warehouse.

952

---

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1688

---

How do we call shell scripts from informatica?

1104

---

What is joiner transformation in informatica?

1043

---

Why update strategy and union transformations are active? Explain with examples.

1235

---

what is INFORMATICA TESTING process

2286

---

How do you convert single row from source into three rows into target?

1153

---

What are the databases that informatica can connect to windows?

1044

---

What are the settings that you use to configure the joiner transformation?

1049

---