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
- 13862 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
Enlist few areas or real-time situations where informatica is required.
How to join three sources using joiner? Explain though mapping flow.
Make a note of the quantity vaults made in informatica?
How many ways a relational source definition can be updated and what are they?
What is the procedure for creating independent data marts from informatica 7.1?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
How can we handle two sessions in informatica?
Briefly define reusable transformation?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
what is the size of your data warehousing?
Is there any target staging area in informatica not staging area
What is the need of etl tools?
Explain lookup transformation in informatica
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
