How to send duplicates to one target and unique rows to one
target?target is empty
Answer Posted / shiva
s-->sq-->agg-->rtr-->tgt1
'--> tgt2
in aggr take two ports count(*)=1
count(*)>1 take group by on column
send this to rtr(create 2 groups in rtr)
Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
How to partition the Session?
What are the tuning techniques you applied during your last project
Explain the features of connected and unconnected lookup.
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Explain scd type 3 through mapping.
How do you use reject loader.
Explain joiner transformation in informatica
Mention some types of transformation?
Explain the use of aggregator cache file?
Why do you use Mapping Parameter and mapping variable?
hi real timers . iam waiting for ur reply regarding ETL TESTING
Whats the difference between informatica powercenter server, repositoryserver and repository?
Can you use flat files in Mapplets.
How identifying bottlenecks in various components of informatica and resolving them?
What are Dimensional table?