Answer Posted / naidu.k

Connected Lookup
Its can recieve multiple input ports and returns
multiplepoutputorts
it is part of mapping data flow
when lookup condition no match Data the integration services
returns insert the data
when lookup condition match Data The integration services
returns update the Data
default values supports
UNConnected Lookup
Its not part of mapping data flow it can recieve multiple
input ports and return single output ports.
when lookup condition no match data the integration services
returns null values
when lookup condition matchdata the integration srvices
returns update data
default values removed
I

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1674

---

What is the use of an aggregator cache file?

1245

---

How can you increase the performance in joiner transformation?

1246

---

can u any challenge your project?

2083

---

What is an unconnected transformation?

1128

---

Why do we need informatica?

1053

---

Explain lookup transformation in informatica

1124

---

Repository user profiles

1811

---

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2477

---

What is an expression transformation in informatica?

1088

---

What are the differences between joiner transformation and source qualifier transformation?

1235

---

What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1121

---

how to load dimension table and fact table. plz tell me the steps.

2140

---

What are the issues you have faced in your project? How did you overcome those issues?

2411

---

What is target designer and target load order?

1167

---