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
- 6388 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
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is rank transformation?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Can anyone tell me the new features in Informatica 9 Version?
Define mapplet?
What are the types of caches in lookup?
How you can differentiate between connected lookup and unconnected lookup?
How can we delete duplicate rows from flat files?
Whats the difference between informatica powercenter server, repositoryserver and repository?
How to configure mapping in informatica?
Mention some types of transformation?
What is the benefit of partitioning a session?
How will the document be delivered to me?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Reusable transformation and shortcut differences
