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
- 13595 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
What are the different versions of informatica?
What is lookup change?
scenario where i can use only concurrent execution of workflow.
How would you join a node to the already existing domain?
Explain the pipeline partition with real time example?
How to start a workflow using pmcmd command?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
How to elaborate tracing level?
Different qualification between a related rotate toward the sky and isolates look upward?
What differs when we choose the sorted input for aggregator transformation?
EXL informatica Questions
difference between repository database and repository service?
write a query to retrieve the latest records from the table sorted by version(scd)
What is informatica etl tool?
What are the tasks that source qualifier perform?
