1. Lookup T/R supports Non-Equi Joins. Where as Joiner T/R does not suppo

what is the diff b/w union and joiner and lookup?

Question Posted / rajesh myle

Answer Posted / rajesh myle

1. Lookup T/R supports Non-Equi Joins. Where as Joiner
T/R does not support the Non Equi Joins. (Joiner T/R
supports only Equi Joins(i.e. ‘=’))

Is This Answer Correct ?

5 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What are the main issues while working with flat files as source and as targets ?

1141

How to use procedural logic inside infromatica?

1203

Difference between Target-based loading and constraint-based loading?

983

What does update strategy mean, and what are the different option of it?

1082

What differs when we choose the sorted input for aggregator transformation?

1008

Explain transaction control transformation in informatica

1249

What do you understand by a term domain?

1110

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

1105

Explain why we use partitioning the session in informatica?

1071

What are data-driven sessions?

1184

What are mapplets?

1254

Can informatica load heterogeneous targets from heterogeneous sources?

1172

Briefly define reusable transformation?

1116

what is the difference between informatica6.1 and infomatica7.1

2252

If informatica has its scheduler why using third party scheduler?

1245