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
- 10782 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 informatica metadata?
What is different between the data warehouse and data mart?
How many types of sessions are there in informatica.please explain them?
Can you use flat files in Mapplets.
Explian the Process of deployment groups in informatica
Whats the difference between informatica powercenter server, repositoryserver and repository?
How big was your fact table
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
How to handle decimal places while importing a flatfile into informatica?
What is the maplet?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What is decode in informatica?
Difference between Target-based loading and constraint-based loading?
What is a rank transform?
What is the use of code page?
