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
- 7673 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
Define mapping and session?
What is the meaning of up gradation of repository?
In which transformation you cannot drag ports into it?
How to update source definition?
What is aggregate cache in aggregator transformation?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Differences between connected and unconnected lookup?
What is Data Caches size?
What are the different types of transformation available in informatica.
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Explain direct and indirect flat file loading (source file type) - informatica
Plz can any one say me how to get the informatica certification materials and dumps
Which transformation is needed while using the Cobol sources as source definitions?
What is a repository? And how to add it in an informatica client?
What is meant by query override?
