Can we use Lookup instead of Joiner to join 2 tables?
If yes which is faster and why?
Answer Posted / sunil
Joiner is faster than lookup. because by default lookup writes order by clause on every column connected to that transformation which decreses the performance..so joiner is faster than lookup..
If anything wrong pls let me know...am looking for job..
Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Define mapping and session?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
How to load last n records of file into target table - informatica
What is resilience time?
What is workflow monitor?
Tell me about MD5 functions in informatica
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How to partition the Session?
What are the performance considerations when working with aggregator transformation?
What is the use of source qualifier?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Explain the pipeline partition with real time example?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
how to load rows into fact table in data warehouse
What is the benefit of session partitioning?