Answer / nikhil

Using lookupoverride u can join two relational tables but
not flat files . Joniner T is used to join two heterogenous
sources like relational tables from two different databases
or flat file sources.

Answer / kotesh

using lookup override we can join more two table either it
is relational or flatfiles also. and one more advantage is
it supports orderby condition.
but jointrns we can join two tables.

Answer / joshasmita

Using Loopoverride we can join two relational tables but
from same database. With joiner we can two sources of
different types

Hi, What is version control in Informatia ? Can anyone just give an idea or introduction about this? Advance Thanks

2 Answers   IBM,

---

what is worklet and what use of worklet and in which situation we can use it?

4 Answers   Patni, TCS,

---

Is there any target staging area in informatica not staging area

0 Answers   Syntel,

---

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

0 Answers  

---

how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)

2 Answers   Sonata,

---

What is a diff between joiner and lookup transformation

16 Answers   CTS, Satyam, TCS, UHG,

---

what is the complex transformation you used in informatica

0 Answers   TCS,

---

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

0 Answers  

---

how i will stop my workflow after 10 errors

2 Answers   HP,

---

in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?

9 Answers   Target,

---

what is the hint? how to use it to reduce the query processing in program?

3 Answers   Cegedim,

---

how do u fnd the duplicate rows and how to delete the duplicate rows?

2 Answers   IBM,

---