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
- 7861 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 promote a non-reusable transformation to reusable transformation?
can u any challenge your project?
What is the difference between writing a joiner query in ANSI style and THETA style?
Design time, run time. If you don't create parameter what will happen
How will the document be delivered to me?
Different qualification between a related rotate toward the sky and isolates look upward?
What does role playing dimension mean?
EXL informatica Questions
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
How to do unit testing in informatica? How to load data in informatica ?
design of staging area?
What is lookup transformation?
Does an informatica transformation support only aggregate expressions?
Enlist some properties of sessions.
What does reusable transformation mean?
