What is the difference between Informatica Router and Filter?

Asked by Last Modified  

Follow 2
Answer

Please enter your answer

Online Mathematics tutor with 8 years experience(Online Classes for 10th to 12th)

In Informatica, the Filter transformation removes rows that don't meet a specified condition, while the Router transformation routes data based on multiple conditions to different output groups, including a default group for unmatched rows.
Comments

"Rajesh Kumar N: Guiding Young Minds from 1 to 12 with Expertise and Care"

Router: Multiple output groups. Filter: Single output group. Router is more efficient when handling multiple conditions.
Comments

C language Faculty (online Classes )

The filter transformation removes the rejected records. The router transformation allows the rejected records in the default group. In this transformation, a single source (or input) can be connected with a single target (or output) table.
Comments

View 1 more Answers

Related Questions

What is Informatica BDE?
Informatica BDE, now known as Big Data Management (BDM), is a data integration tool from Informatica that allows users to push mapping execution onto a Hadoop cluster, enabling big data integration and...
Yogesh
0 0
5
I am thinking of learning Informatica. What is its scope and how good is it to start a career in Informatica
Yes. Informatica is the leading ETL tool in the market. It's even true that with out knowing SQL and UNIX it is just a waste of energy... I give online training on informatica and Cognos with SQL and UNIX as free.
Jyoti Gangal
How about Informatica Certification? I am a fresher and I just did informatica developer training privately. What would be the knowledge level to attempt Informatica certification programs?
Going for certification would need good amount of in-depth knowledge of each and every basic and advanced topics blended with knowledge from the administration side. Try out different scenarios available...
Narmatha
0 0
9

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

Scd1 implementation without using update strategy
Hi Folks, Please find out way to implement scd1 without using update stategy transformation for update flow. What all configuration you need to consider for this scenario.
A

Ashish Panchbudhe

0 0
0

Will Big Data clean up ETL
The fuss in the Datawarehousing world is will Big Data kill the existing ETL tools. The answer is a big "NO". Big Data with the combination of ETL will pave the way for easy reporting and data maintenance....

ETL Informatica
Data Acquisition: GUI based ETL ETL applications can be designed with a simple graphical user interfacing point and click techniques Ex: Informatica, Datastage, Abintio ODI(Oracle Data Integrator)...

Short notes about Informatica Powercenter
Informatica Powercenter is a widely used ETL tool to build the warehouses. It is most popular ETL tool ever since it released in 1993.The components of Informatica Powercenter will allow us to Extract...

Best way to learn any software Course
Hi First conform whether you are learning from a real time consultant. Get some Case Studies from the consultant and try to complete with the help of google not with consultant. Because in real time same situation will arise. Thank you

Recommended Articles

Applications engineering is a hot trend in the current IT market.  An applications engineer is responsible for designing and application of technology products relating to various aspects of computing. To accomplish this, he/she has to work collaboratively with the company’s manufacturing, marketing, sales, and customer...

Read full article >

Almost all of us, inside the pocket, bag or on the table have a mobile phone, out of which 90% of us have a smartphone. The technology is advancing rapidly. When it comes to mobile phones, people today want much more than just making phone calls and playing games on the go. People now want instant access to all their business...

Read full article >

Hadoop is a framework which has been developed for organizing and analysing big chunks of data for a business. Suppose you have a file larger than your system’s storage capacity and you can’t store it. Hadoop helps in storing bigger files than what could be stored on one particular server. You can therefore store very,...

Read full article >

Business Process outsourcing (BPO) services can be considered as a kind of outsourcing which involves subletting of specific functions associated with any business to a third party service provider. BPO is usually administered as a cost-saving procedure for functions which an organization needs but does not rely upon to...

Read full article >

Looking for Informatica Training?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you