in Technology by

What are the similarities and differences between ROUTER and FILTER?

1 Answer

0 votes
by

The differences are:

Router Vs Filter

Advantages of Router transformation over Filter transformation:

  • Better Performance; because in mapping, the Router transformation Informatica server processes the input data only once instead of as many times, as you have conditions in Filter transformation.
  • Less complexity; because we use only one Router transformation instead of multiple Filter transformations.
  • Router transformation is more efficient than Filter transformation.

For E.g.:

Imagine we have 3 departments in source and want to send these records into 3 tables. To achieve this, we require only one Router transformation. In case we want to get same result with Filter transformation then we require at least 3 Filter transformations.

Similarity:

A Router and Filter transformation are almost same because both transformations allow you to use a condition to test data.

Related questions

0 votes
    What are the similarities and differences between Tableau and Palantir?...
asked Oct 30, 2020 in Technology by JackTerrance
0 votes
    Differentiate between Router and Filter Transformation?...
asked Mar 28, 2021 by JackTerrance
0 votes
    There are similarities between the instructor entity set and the secretary entity set in the sense that ... Database Systems Design and Implementation of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
    I am developing a single-page-application using vue-cli3 and npm. The problem: Populating a basic integer ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked May 7, 2022 in Education by JackTerrance
0 votes
    I am developing a single-page-application using vue-cli3 and npm. The problem: Populating a basic integer ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Apr 24, 2022 in Education by JackTerrance
0 votes
    What is the difference between hub,switch and router?In tabular form? Select the correct answer from above options...
asked Dec 24, 2021 in Education by JackTerrance
0 votes
    What is the difference between Hub, Switch, and Router?...
asked Nov 20, 2020 in Education by Editorial Staff
0 votes
    Similarities passed from one generation to next are called a. Hereditary features b. Similarities c. Twins d. none...
asked May 14, 2021 in General by JackTerrance
0 votes
    What are router command that is used to display RAM content and NVRAM Content?...
asked Aug 22, 2021 in Technology by JackTerrance
0 votes
    What are the types of groups in router transformation?...
asked Mar 26, 2021 in Technology by JackTerrance
0 votes
    Tor (The Onion Router) is not a service or part of the darknet. 1) True 2) False...
asked Dec 30, 2020 in Technology by JackTerrance
0 votes
    ________________ is a network construct over the internet that is encrypted. It offers anonymity to its users. Tor (The Onion ... . 1) Freenet 2) Darknet 3) ARPANET 4) Stuxnet...
asked Dec 30, 2020 in Technology by JackTerrance
0 votes
    Explain what is Backbone.js router is used for ?...
asked Nov 13, 2020 in Technology by JackTerrance
0 votes
    router examine _____ of given data package and forward table to device best way to transfer data packets Select the correct answer from above options...
asked Dec 2, 2021 in Education by JackTerrance
0 votes
    I am using BrowserRouter as Router from react-router-dom. I want to host my application at a path ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Apr 14, 2022 in Education by JackTerrance
...