Interested to Buy Any Domain ? << Click Here >> for more details...
suppose if we have dublicate records in a table temp n now
i want to pass unique values to t1 n dublicat values to t2
in single mapping using aggregator & router? how
- 7 Answers
- 13696 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / nikita jain
for this query we can use aggregator row wise calculation and handle then via router
col1 col2
1 2
1 2
1 2
3 4
3 4
5 6
O/P
Table with unique records:
1 2
3 4
5 6
Table with rest of the records
1 2
1 2
3 4
After SQ take a sorter transformation sort on col1 asc then an expression transformation
col1
col2
v_count iif(col1=prev_col1 and col2=prev_col2, vcount+1,1)
o_count v_count
prev_col1 col1
prev_col2 col2
Take a Router transformation , make 2 groups
Group1 : 0_count=1
Group2 : Default (it will come automatically)
Connect first group with unique target table
and second with other table
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Describe an informatica powercenter?
How to implement security measures using repository manager?
Explain pushdown optimization and types in informatica
What are the different clients of powercenter?
What are session parameters ? How do you set them?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
How to join three sources using joiner?
How does a sorter cache works?
How big was your fact table
what is informatica metadata?
Why update strategy and union transformations are active? Explain with examples.
What is the maplet?
How can we create index after completion of load process?
How an expression transformation differs from aggregator transformation?
How might you approve all mappings in the archive all the while?
