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 tasks that can be performed using sq?

1144

Can informatica load heterogeneous targets from heterogeneous sources?

1235

what is INFORMATICA TESTING process

2334

What is joiner transformation in informatica?

1101

Can anyone tell me the new features in Informatica 9 Version?

2214

Does an informatica transformation support only aggregate expressions?

1088

Differences between connected and unconnected lookup?

1273

What are the reusable transformations?

1221

Repository user profiles

1812

What are the components of workflow manager?

1159

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2293

What is workflow? What are the components of workflow manager?

1233

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2116

What is sq transformation?

1233

What is meant by target load plan?

1030