Answer Posted / reni

Create one dummy record for each table:
from 2 source qualifiers connect a expression
transformation to create a output port as "Dummy" & assign
the value "1" to that port.
Then in joiner join based on this dummy port of two
different source.

differences between service based and product based?

1979

---

How to delete duplicate row using informatica?

992

---

Explain how to import oracle sequence into informatica?

961

---

What is rank transform?

952

---

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1941

---

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1040

---

What is the different lookup cache(s)?

1043

---

what is song in infrmatica...?

2175

---

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1045

---

Separate from a database, an information bazaar, and an information stockroom?

1027

---

Differentiate between joiner and lookup transformation?

1058

---

Why update strategy and union transformations are active?

997

---

How many numbers of sessions can one group in batches?

1028

---

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

6939

---

What is a router transformation?

1060

---