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


Please Help Members By Posting Answers For Below Questions

How are the sources and targets definitions imported in informatica designer?

666


Under what condition selecting sorted input in aggregator may fail the session?

661


What are the tasks that can be performed using sq?

611


What are the new features of informatica 9.x in developer level?

557


How big was your fact table

1314






What is update strategy transform?

569


Different circumstance which drives informatica server to expel records?

549


What is domain in terms of informatica?

561


What are some examples of informatica etl programs?

533


Explain direct and indirect flat file loading (source file type) - informatica

826


What is the difference between router and filter?

647


Scheduling properties,whats the default (sequential)

1462


Explain the etl program with few examples.

546


define galaxy repository in informatica

1724


What is data movement mode in Informatica and difference between them?

618