Answer Posted / rayudu

Connected lookup is used to lookup on each and every row
bjut unconnected lookup is used to lookup only when the
condition is true i,e unconnetcec is used only for selectetd
rows so obviously unconnected is faster .


Regards,
rayudu.

How do you change a non-reusable transformation to reusable transformation?

999

---

When do you use sql override in a lookup transformation?

1100

---

How to update or delete the rows in a target, which do not have key fields?

1178

---

What is a stored procedure transformation?

1056

---

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)

1628

---

How to join three sources using joiner?

1115

---

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2067

---

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1270

---

what is index?how it can work in informatica

2041

---

what is unit testing?tell me proceedure

2223

---

How do you handle two sessions in Informatica

1166

---

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

1241

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

2049

---

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9827

---

Repository user profiles

1764

---