Interested to Buy Any Domain ? << Click Here >> for more details...
i have two coloumn
emp_no sal
1 3000
2 3000
3 3000
4 4000
5 5000
6 2700
7 4500
i just need output by removing duplicate.my answer should be
emp_no sal
1 3000
2 4000
3 5000
and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression
- 3 Answers
- 7860 Views
- I also Faced
- E-Mail Answers
Answer Posted / nsatyabrat7
Use distinct in source qualifier and rest will be taken care
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What is status code in informatica?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Differentiate between Load Manager and DTM?
Enlist the various types of transformations.
What is expression transformation?
What the difference is between a database, a data warehouse and a data mart?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What is the status code in stored procedure transformation?
How can you generate reports in informatica?
What are the differences between a connected lookup and unconnected lookup?
can we override a native sql query within informatica? Where do we do it?
What is the benefit of partitioning a session?
What is a rank transform?
What are the main issues while working with flat files as source and as targets ?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
