By using Filter Transformation,How to pass rows that does
not satisfy the condition(discarded rows) to another target?
Answer Posted / yogesh
Use Router tranformation. All the rows which doesnot match
the group (filter condition) will be routed to default
group. Connect default group ports to 2nd target.
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
Differentiate between joiner and lookup transformation?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Explain constraint based loading in informatica
Differentiate between Load Manager and DTM?
What is exclusive and normal mode for repository services?
What is the status code in stored procedure transformation?
Explain pushdown optimization and types in informatica
What is informatica etl tool?
What is decode in informatica?
Explain sessions. Explain how batches are used to combine executions?
What is the sequence generator transformation in informatica?
What is the function of look up transformation?
What is enterprise data warehousing?
Write the program through which the records can be updated?
Enlist the differences between database and data warehouse.