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
- 7672 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
Explain sessions?
How big was your fact table
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
Explain Dataware house architecture .how data flow from intial to end?
What do think which one is the better joiner or look up?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
tell me 5 session failure in real time how can you solve that in your project?
What is an aggregator transformation?
How do you take back up of repository?
hi real timers . iam waiting for ur reply regarding ETL TESTING
How do you remove duplicate records in informatica? And how many ways are there to do it?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What are the performance considerations when working with aggregator transformation?
What is the need of an ETL tool?
