Answer Posted / justin
Filter transformation is used to filter out unwanted records that does not satisfy its condition
Router Transformation provide you the flexibility of populating multiple target depending upon the different type of conditions
I was able to find a good article on it at
http://www.tecktricks.com/difference-between-filter-transformation-and-router-transformation-in-informatica/
Hope it will help you :)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What are the different transaction levels available in transaction control transformation?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Why update strategy and union transformations are active? Explain with examples.
What is the surrogate key?
What is sq transformation?
whats the logic to load the lower level of granularity of data to fact table.
What is a repository? And how to add it in an informatica client?
What is the procedure for creating independent data marts from informatica 7.1?
What are active and passive transformations?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
Explain joiner transformation in informatica
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Describe the impact of several join conditions and join order in a joiner transformation?
