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
- 13357 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 differs when we choose the sorted input for aggregator transformation?
What the difference is between a database, a data warehouse and a data mart?
To import the flat file definition into the designer where should the flat file be placed?
What is the use of code page?
How many transformations can be used in mapplets.
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
During the running session, output files are created by informatica server. Enlist few of them.
What are the mapping parameters and mapping variables?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What is meant by target load plan?
Tell me about MD5 functions in informatica
What is joiner transformation in informatica?
What are pre and post-session shell commands?
What are the components of the workflow manager?
