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
Different circumstance which drives informatica server to expel records?
Differentiate between a repository server and a powerhouse?
how to load rows into fact table in data warehouse
How to create or import flat file definition in to the warehouse designer?
Explain pushdown optimization $pushdownconfig parameter - informatica
What are the different versions of informatica?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Explain the different dimensions.
What is update strategy transform?
How can we create index after completion of load process?
How to elaborate tracing level?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Briefly explain the aggregator transformation?
r u done any partitions in ur project?
How many types of sessions are there in informatica.please explain them?