What do think which one is the better joiner or look up?

Sharad Jaiswal
Sharad Jaiswal

Posted On: Feb 22, 2018

 

We can’t compare which one is a better joiner or look up because both have their own functionalities .its all depends on table size and source. If we are using flat file sorted joiner is more effective than look up because of joiner caches fewer rows .lookup caches who file in always. If we are using database lookup is effective when the database can return sorted data fast and the amount of data is small.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Informatica Interview Questions

    In warehouses how many schemas are there?

    There are four Schema’s They are: Star Schema Snow Flake Schema Galaxy Schema Fact Constellation Schema ..

    Informatica Interview Questions

    Could you explain what is Enterprise data warehouse?

    In enterprise data warehousing all organization data is created at a single point of access .data can be provided a glo..

    Informatica Interview Questions

    What is different between the data warehouse and data mart?

    A Data Mart Is a simple form of a data warehouse that is focused on a single subject or functional areas such as sales ..