if i have a file having record sal=10000,and when use router
with two groups having condition sal>5000 in one
group,sal>7000 in other group.and if two groups connected to
two targets.in which target sal=10000 will go?
Answer Posted / arunachalam
The record goes to both the tables
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
While importing the relational source definition from the database, what are the metadata of source that will be imported?
How to generate sequence numbers using expression transformation?
Why do you use Mapping Parameter and mapping variable?
What is a grid in Informatica?
What is a rank transform?
How do you load alternate records into different tables through mapping flow?
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
What is decode in static cache?
Can we override a native sql query within informatica?
What do you mean by filter transformation?
What is a pre-defined event and user-defined event?
Is it possible to create multiple domains on a single Informatica server?
What are the prerequisite tasks to achieve the session partition?
What are the different types of transformation available in informatica.
Define joiner transformation?