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 / prakash kumar kumhar
yes record will store in both target if you r not using any column as a primary key from source column.
if u are using any column from the source as a primary than it will load only in first target i think.
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
How you can differentiate between connected lookup and unconnected lookup?
What do you mean by channel change?
Why union transformation is an active transformation?
Can we override a native sql query within informatica?
According to his methodology what all you need before you build a datawarehouse
Enlist the tasks for which source qualifier transformation is used.
What is an unconnected transformation?
difference between repository database and repository service?
Suppose we do not group by on any ports of the aggregator what will be the output?
What are the types of schemas we have in data warehouse.
Is it possible to use a client with different version than that of its Informatica server?
Define the various join types of joiner transformation?
What is a joiner transformation?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?