Answer Posted / bsgsr

hi, preeti,
u r absolutely correct.
the main functionality is to avoid duplicate rows by
selecting first or last value only when the record kming
from the source has multiple matches with the look up cache.

mail meif u r interested in kt
9866188658 bsgsr12@gmail.com

Enlist the tasks for which source qualifier transformation is used.

1073

---

Do you find any difficulty while working with flat files as source and target?

1146

---

Explain the use of aggregator cache file?

1315

---

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

2071

---

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2168

---

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2443

---

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1555

---

Differentiate between Load Manager and DTM?

2208

---

What are the types of schemas we have in data warehouse and what are the difference between them?

986

---

Is there any way to read the ms excel datas directly into informatica?

1067

---

Why is sorter an active transformation?

1195

---

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

1160

---

What is a node in Informatica?

1085

---

What are the different components of powercenter?

1111

---

Explain pushdown optimization $pushdownconfig parameter - informatica

1193

---