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
- 8562 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / isha
Actually this question is - If any record have duplicate value then put it in T1 and If count is 1 then put in T2.
We have to use aggregator and have to group records based on empid and name
If count(empid) > 1 then T2
If count(empid) =1 then T1
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain direct and indirect flat file loading (source file type) - informatica
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What is rank transformation in informatica
How we can create indexes after completing the load process?
What is data movement mode in Informatica and difference between them?
What is the difference between a repository server and a powerhouse?
What is domain in terms of informatica?
What is meant by incremental aggregation?
What is an expression transformation in informatica?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How you can differentiate between connected lookup and unconnected lookup?
Can we create multiple integration service on single repository?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
