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
- 6867 Views
- I also Faced
- E-Mail Answers
Answer Posted / jayachandra
One solution is use distinct key word on source qualfier as
suppose your table name is emp than on emp_sq
the query is
select emp_no,distinct sal from emp;
2nd sol is make an aggregator transformation here make a
coun()on sal port with group by then put filter
transformation with condition count(sal)=1
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Where is metadata stored?
How might one distinguish in the case of mapping is right or not without associating session?
What is main use of mapplet?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What are roles and groups and benefits of using them?
What is decode in informatica?
How can you differentiate between powercenter and power map?
Explain the different kinds of facts.
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What are the various types of transformation?
How many numbers of sessions can one group in batches?
How to open an older version of an object in the workspace?
draw informatica architecture 8.6 ?
What is flashback table ? Advance thanks
What are the main issues while working with flat files as source and as targets ?
