Answer Posted / padmavathi

Connected Lookup:
Part of the mapping dataflow.
Returns multiple values by linking output ports to
another transformation
Executed for every record passing through the transformation
More Visible, shows where the lookup values are used.

Unconnected Lookup:
Seperate from the mapping dataflow.
Returns one value by checking the return port option for
the output that provides the return value
only executed when the lookup function is called
Less visible, as the look is called from an expression
within another transformation
Default values are ignored

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

2020

---

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1178

---

How does a rank transform differ from aggregator transform functions max and min?

1263

---

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1955

---

lookup transformation with screenshots

4050

---

What are the data movement modes in informatica?

1208

---

What is the sql query overwrite in source qualifier in informatica

1142

---

Enlist the advantages of informatica.

1099

---

Partition, what happens if the specified key range is shorter and longer

2552

---

How do you update the records with or without using update strategy?

1160

---

Under what condition selecting sorted input in aggregator may fail the session?

1175

---

How many dimensions are there in informatica?

1134

---

How to extract the informatica rejected data?

1255

---

What is a joiner transformation?

1035

---

What is meant by pre and post session shell command?

1199

---