Answer Posted / divi

Alternative to Lookup id Joiner.we need to import source
structure of target in Source Analyser and bring that into
mapping and use it for comparison like Lookup.

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

7072

---

Is there any target staging area in informatica not staging area

2508

---

How is union transformation utilized?

952

---

Explain about cumulative Sum or moving sum?

983

---

What are the conditions needed to improve the performance of informatica aggregator transformation?

1038

---

Can you generate sequence numbers without using the sequence generator transformation?

1054

---

Is it possible to revert a global repository to local one and why?

1026

---

What is deployment group?

1132

---

Explain about Informatica server process that how it works relates to mapping variables?

1010

---

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

2317

---

What is a pre-defined event and user-defined event?

976

---

what is diff b/t sorter t/r and agg have the option sorter property...

2133

---

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

2081

---

What are different types of transformations available in informatica?

938

---

How to do the error handling of if ur source is flatfiles?

1913

---