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 |
My source table having some records ,i want load 1st record and last record into one target?
What is the difference between writing a joiner query in ANSI style and THETA style?
There are 100 lines in a file. How to print line number 31-50 and 81-90 in unix with a single command.
What is a difference between complete, stop and abort?
What is confirmed dimension?
what are the difference between Informatica 7.1 and 8.1?
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com
What is workflow variable? When we use workflow variable? Can any one explain me with one example???
I have a scenario with lookup table. in that lookup table have colomns, but i need to process only 10 colomns out of 50. Please te me how can we acheive it?
what is mapping parameter and mapping variables
Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how