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 few areas or real-time situations where informatica is required.

1019

---

Explain incremental aggregation in informatica

1064

---

What is different between the data warehouse and data mart?

1000

---

can u any challenge your project?

1971

---

Enlist some properties of sessions.

1020

---

What is the need for an etl tool?

1009

---

How does the aggregator transformation handle null values?

1084

---

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1628

---

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

887

---

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

2266

---

Explain where to store informatica rejected data? How to extract the informatica rejected data?

950

---

How can you define user defied event?

975

---

what are the deliverables?in your project?

2084

---

How you know when to use a static cache and dynamic cache in lookup transformation?

1791

---

How to configure mapping in informatica?

1119

---