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
- 11028 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / krish
using AGG we get can't get the above o/p
| Is This Answer Correct ? | 1 Yes | 7 No |
Post New Answer View All Answers
What is fact table? Explain the different kinds of facts.
What are the differences between joiner transformation and source qualifier transformation?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
How big was your fact table
What is the difference between a repository server and a powerhouse?
What do you mean by enterprise data warehousing?
What is deployment group?
What are the performance considerations when working with aggregator transformation?
What is confirmed fact in dataware housing?
What are junk dimensions?
design of staging area?
What are the popular informatica products?
What is the difference between router and filter?
What are the components of Informatica? And what is the purpose of each?
