| |
GeekInterview.com > Interview Questions > Data Warehousing > Informatica
| Print | |
| Question: What is Router transformation?
Answer: Router transformation allows you to use a condition to test data. It is similar to filter transformation. It allows the testing to be done on one or more conditions.
|
| October 10, 2005 13:19:24 |
#7 |
| ganesh |
Member Since: Visitor Total Comments: N/A |
Router Transfermation
|
| Router is an Active and Connected transformation. It is similar to filter transformation. But in filter transformation eliminate the data that do not meet the condition whereas router has an option to capture the data that do not meet the condition. It is useful to test multiple conditions. It has input, output and default groups. For example, if we want to filter data like where deptno=10, deptno=20, deptno=30 and all other deptno's. It’s easy to route data to different tables. |
| |
Back To Question | |
