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
- 5948 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 a mapplet/worklet in informatica?
What is union transformation?
Performance tuning( what you did in performance tuning)
What do you mean by filter transformation?
Which version configuration tool used in ur project?
wat are deployement groups in informatica, how it will be used for developers
While migrating the data from one environment to another environment how would you manage the connections?
What are the types of schemas we have in data warehouse.
What is pmcmd command?
What are the tasks that source qualifier perform?
what is the difference between informatica6.1 and infomatica7.1
How is union transformation utilized?
Where are the source flat files kept before running the session?
Define update strategy?
How to go to the older version for a mapping?
