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
- 8728 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
State the differences between sql override and lookup override?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
can u any challenge your project?
What is a snowflake schema?
How to elaborate tracing level?
Why do you use Mapping Parameter and mapping variable?
Explain what are the different versions of informatica?
what is mean by complex business rule ?
How can repository reports be accessed without sql or other transformations?
server hot-ws270 is connect to Repository B. What does it mean?
What is the function of union transformation?
What is dimensional table? Explain the different dimensions.
what is index?how it can work in informatica
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
