Interested to Buy Any Domain ? << Click Here >> for more details...
select * from emp where sal>(select min(sal) from emp) how
to implement the same in informatica ?
- 5 Answers
- 8941 Views
- Puma, I also Faced
- E-Mail Answers
Answer Posted / chandra mouli
In Mapping take two transfermations.
1.aggrigate transfermation
2.filter transfermation.
in aggrigate add one output port is minsal
minsal=MIN(SAL).next in filter condition SAL > minsal.
next link the ports to target.
| Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
What is the need for an etl tool?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Explain target update override in informatica
Explain constraint based loading in informatica
What is Cognos script editor?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
What is aggregator transformation in informatica?
What are roles and groups and benefits of using them?
What is Session and Batches?
what is the -ve test case in your project.
How can a transformation be made reusable?
which one is better performance wise joiner or look up
Where are the source flat files kept before running the session?
Can we create a node as a gateway node and the same node can be assigned to a grid?
