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
- 5965 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
What is sorter transformation?
Explain lookup transformation is active in informatica
what is $$$$?
What is persistent lookup cache?
Whats the difference between informatica powercenter server, repositoryserver and repository?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
wf dont have integration severances how you can run?
What are the new features of Power Center 5.0?
What is a grid in Informatica?
How do you convert single row from source into three rows into target?
How do you load only null records into target?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
How to create or import flat file definition in to the warehouse designer?
What is deployment group?
