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 / sujana
record goes 2 both tables..it wil be passed multiple times
| Is This Answer Correct ? | 28 Yes | 1 No |
Post New Answer View All Answers
differences between service based and product based?
What is the need of an ETL tool?
Why update strategy and union transformations are active?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
In how many ways we can create ports?
What are the differences between a connected lookup and unconnected lookup?
Differentiate between router and filter transformation?
have u done any performance tuning? how u ll do?
How do you load first and last records into target table?
What is update strategy transform?
Write the prerequisite tasks to achieve the session partition?
What are the new features of informatica 9.x in developer level?
Whats there in global repository
Which transformation should we use to normalise the COBOL and relational sources?
What are the restrictions of union transformation?