Answer Posted / chandra

Joiner will join the two different data sources based on a
join condition ,and pass only the rows which satisfy that
condition.discards the remaining rows.

Joiner transformation supports 4 types of joins at
Informatica level
Normal
Master Outer
Detail Outer
Full Outer

LookUp Transformation

Lookup transformation basically for Reference,based on the
lookup condition.when u want some data based on target
data ,will take lookup on that particular table and
retrieve the corresponding fields from that table.
we can override the lookup transformation using the SQL
query.

How do you promote a non-reusable transformation to reusable transformation?

878

---

In informatics server which files are created during the session rums?

833

---

What are the various types of transformation?

849

---

what is INFORMATICA TESTING process

2019

---

How do you load only null records into target?

928

---

---

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

1973

---

Explain the pipeline partition with real time example?

852

---

What is an expression transformation in informatica?

731

---

What is a passive transformation?

805

---

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?

1754

---

How to update or delete the rows in a target, which do not have key fields?

874

---

Which means the first record should come as last record and last record should come as first record and load into the target file?

806

---

differences between service based and product based?

1749

---

What is a grid in Informatica?

804

---

How will the document be delivered to me?

798

---