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
- 7736 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
Why filter transformation is an active one?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Describe the impact of several join conditions and join order in a joiner transformation?
How do you set a varible in incremental aggregation
State the differences between sql override and lookup override?
What are session parameters ? How do you set them?
How to load data in informatica ?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Define the various join types of joiner transformation?
lookup transformation with screenshots
Define mapping and session?
Enlist some properties of sessions.
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
How identifying bottlenecks in various components of informatica and resolving them?
