which is better perfomancewise lookup or joiner and why?can anyone give example?
Answer Posted / lokesh.t
lookup is having multiple advantages compare to joiner
transformations :-it will avoid duplicate vlues . by
using first last value in lkp values . with lkp we can n
nnumber of tables. where as in joiner we can join only
two tables
Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
How are the sources and targets definitions imported in informatica designer?
Under what condition selecting sorted input in aggregator may fail the session?
What are the tasks that can be performed using sq?
What are the new features of informatica 9.x in developer level?
How big was your fact table
What is update strategy transform?
Different circumstance which drives informatica server to expel records?
What is domain in terms of informatica?
What are some examples of informatica etl programs?
Explain direct and indirect flat file loading (source file type) - informatica
What is the difference between router and filter?
Scheduling properties,whats the default (sequential)
Explain the etl program with few examples.
define galaxy repository in informatica
What is data movement mode in Informatica and difference between them?