How we can get unique records into one target table and
duplicate records into another target table??
Answers were Sorted based on User's Feedback
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 |
What is metadata reporter?
Target is zero file and how can you send the email?
what is data driven?
What are multi-group transformations?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Which is better performance wise database or file?How?
What is the advantage of persistent cache? When it should be used.
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?
How do you Merge multiple Flat files for example 100 flat files with out using Union T/F
what are the differences between powercenter 8.1 and powercenter 8.5?
what is DSS?