Interested to Buy Any Domain ? << Click Here >> for more details...
hi all hi have flat file like below my requirement is
empid,ename,sal,loc
101,vamshi,5000,hyd
101,vamshi,5020,hyd
201,raju,5000,hyd
202,ram,4000,hyd
203,kumar,3500,pune
203,kumar,3500,pune
203,kumar,5000,hyd
203,kumar,6000,hyd
i want the o/p like this
in one target
201,raju,5000,hyd
202,ram,4000,hyd
and in second target
101,vamshi,5000,hyd
101,vamshi,5020,hyd
203,kumar,3500,pune
203,kumar,3500,pune
203,kumar,5000,hyd
203,kumar,6000,hyd
- 9 Answers
- 11040 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / kamleshmishra291
After SQ Take Aggr group by empid and create a variable port Rows_count=count(1)
Take a router after aggr and create two groups one for uniqe and one for duplicate
in uniqe condition = Rows_count=1
duplicate group condition= Rows_count>1
connect unique group to tgt1
connect duplicate group to java transformation---
add following codes
for (int i=0;i<count;i++)
{
o_empid=i_empid;
o_ename=i_ename;
o_loc=i_loc;
o_sal=i_sal;
generateRow();
}
connect java transformation to tgt2
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is $$$$?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
How would you join a node to the already existing domain?
What is an expression transformation in informatica?
can we override a native sql query within informatica? How do we do it?
Which files are created during the session rums by informatics server?
What is repository manager?
Difference between Data and Index Caches?
Differentiate between sessions and batches?
How to update or delete the rows in a target, which do not have key fields?
How do you load only null records into target?
What is meant by active and passive transformation?
What is resilience time?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
What are the types of caches in lookup?
