Interested to Buy Any Domain ? << Click Here >> for more details...
How we can get unique records into one target table and
duplicate records into another target table??
- 11 Answers
- 40874 Views
- Deloitte, IBM, iGate, I also Faced
- E-Mail Answers
Answer Posted / durgaprasad
data flow for this one is:
sq-->Aggregater-->Router-->target
in aggregater t/r take 2 output ports and give condition like
uniqe_port---->count(*)=1
duplicate_port--->count(*)>1
connect this one router and in router take 2 groups and
give condition like
uniqgroup=uniqe_port
duplicategroup=duplicate_port
and connect that groups to target
| Is This Answer Correct ? | 15 Yes | 28 No |
Post New Answer View All Answers
What do you understand by term role-playing dimension?
How can informatica be used for an organization?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Define mapplet?
How might one distinguish in the case of mapping is right or not without associating session?
How to update source definition?
What are the types of schemas we have in data warehouse.
Can we create a Integration service without a Repository service and vice versa?
waht type of interface is used for testing the data in informatica
can anyone explain me about retail domain project in informatica?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Have you worked with/created Parameter file
Write the program through which the records can be updated?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Differences between version 7.x and 8.x.
