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
- 10796 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
What is a snowflake schema?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Can we create a node as a gateway node and the same node can be assigned to a grid?
What are Dimensional table?
How can we use mapping variables in informatica?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What can we do to improve the performance of informatica aggregator transformation?
What is meant by active and passive transformation?
Write the different tools in the workflow manager?
State the limitations where we cannot use joiner in the mapping pipeline?
what is $$$$?
list out all the transformations which use cache?
Explain the different kinds of facts.
how we can load rejected record's at run time?(not through bad files)
explain one complex mapping with logic? sales project?
