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
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 source qualifier transformation in informatica?
Explain what are the different types of transformation available in informatica.
What are the differences between a connected lookup and unconnected lookup?
How to do unit testing in informatica? How to load data in informatica ?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
r u done any partitions in ur project?
What are the main issues while working with flat files as source and as targets ?
Which are the different editions of informatica powercenter that are available?
What is a filter transformation and why it is an active one?
can you please explain me pre session and post session options?
What is a code page?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What are the uses of etl tools?
What is data transformation manager process?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?