Answer Posted / suneelkumar.dasari

If u want to use the same look up T/R more than one time,you should use compulsory Unconnected lookup.A common use for unconnected Lookup transformations is to update slowly changing dimension tables.I know these 2 uses.

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1330

---

What are junk dimensions?

1114

---

What are the new features of informatica 9.x in developer level?

1053

---

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

1021

---

What is mapping debugger?

1069

---

Which transformation is needed while using the Cobol sources as source definitions?

1221

---

What are the guidelines to be followed while using union transformation?

1208

---

Explain lookup transformation in informatica

1131

---

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

2087

---

Why sorter is an active transformation?

1252

---

Differentiate between a database and data warehouse?

1194

---

Slowly changing dimensions, types and where will you use them

1773

---

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

1224

---

What is persistent lookup cache?

1098

---

What are the different versions of informatica?

1337

---