Answer Posted / rag

Hi You can do this another way also
put the expresession transforamtion and read some previous
record with the currect record or any unique column value in
the expression and if they are equal then assign the
flag(means duplicate flag) else
assign the new flage.
pass the duplicate flag records to the filter and goes to
the TB(duplicate records target) and unique values to the
origonal target

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2058

---

How many ways are there to do 'remove duplicate records in informatica'?

992

---

What is lookup transformation?

1026

---

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

1068

---

What are the types of data warehouses?

1503

---

Is it possible to define a single node as a Gateway node as well as worker node?

1106

---

How does the aggregator transformation handle null values?

1134

---

Briefly define reusable transformation?

1119

---

Explain lookup transformation is active in informatica

1074

---

During the running session, output files are created by informatica server. Enlist few of them.

970

---

What is intricate mapping?

1179

---

How can we create index after completion of load process?

1109

---

If informatica has its scheduler why using third party scheduler?

1249

---

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

1053

---

What are the different clients of powercenter?

1045

---