Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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 ?

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


Please Help Members By Posting Answers For Below Questions

What is resilience time?

1148


What is lookup change?

1052


What does role playing dimension mean?

1047


What is the way to execute pl/sql script using informatica mapping?

1612


How to extract sap data using informatica? What is abap? What are idocs?

1183


How to elaborate tracing level?

1181


explain about unit testing? in real time?

2209


what are the Methods For Creating Reusable Transformations?

1177


What is the maplet?

1127


what is the end to end process meaning in my project(my project is development)and functionality plz tell me

2011


Mention a few design and development best practices for informatica?

1000


Briefly explain the aggregator transformation?

1010


How can we improve session performance in aggregator transformation?

1117


Can we create a Integration service without a Repository service and vice versa?

1215


What are junk dimensions?

1074