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

explain one complex mapping with logic? sales project?

6678

What is the function of look up transformation?

1127

How do you load alternate records into different tables through mapping flow?

1875

explan ur project architecture?

2075

What are the different types of repositories created using informatica?

1143

Did u used latest transformations of 8.6.0? for what?

1885

r u done any partitions in ur project?

1828

What are the differences between oltp and olap?

976

Please let me know how to make Data masking in informatica..

1733

What is fact table? Explain the different kinds of facts.

1080

What are the modules in Power Center

1683

Describe expression transformation?

1135

What is option by which we can run all the sessions in a batch simultaneously?

1149

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1163

What is pmcmd command?

1130