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
- 7549 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 do you load first and last records into target table?
Can we create multiple integration service on single repository?
What is informatica etl tool?
How to update source definition?
tell me the rules and responsblites in our project(my project is development)
How do you take back up of repository?
How to elaborate powercenter integration service?
Explain incremental aggregation in informatica
What are active transformations.
Scheduling properties,whats the default (sequential)
What is confirmed fact in dataware housing?
What are the features of complex mapping?
What is dimensional table? Explain the different dimensions.
How to load data in informatica ?
can you please explain me pre session and post session options?
