performance wise which one is better in joiner and lookup transformation?why?explain clearly?

Answer Posted / soujanya

before cache joiner after cache lookup

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1439


Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

879


Why is sorter an active transformation?

759


What is the maplet?

697


I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1707






What is informatica? Why do we need it?

743


What is a dimensional model?

660


What is intricate mapping?

690


permutations of mapplet

2138


What is status code in informatica?

682


In what scenario we use to improve session performance by pushdown optimization?can any one give example?

5450


What are the different types of transformation available in informatica.

725


Explain constraint based loading in informatica

748


In informatics server which files are created during the session rums?

731


How can we store previous session logs?

659