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
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
What is target load order?
What could be the possible resons of locks by user?
How can a transformation be made reusable?
What do you understand by term role-playing dimension?
What is the use of source qualifier?
What are roles and groups and benefits of using them?
Can we create a node as a gateway node and the same node can be assigned to a grid?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
if we have a delimiters at unwanted places in a flat file how can we over come those.
How to load the data from people soft hrm to people soft erm using informatica?
How will the document be delivered to me?
wf dont have integration severances how you can run?
Explain incremental aggregation in informatica
Why do you use Mapping Parameter and mapping variable?
Explain what is informatica metadata and where is it stored?