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
- 8738 Views
- Puma, I also Faced
- E-Mail Answers
Answer Posted / guest
Hi,
Use the lookup on emp table .Override the lookup Query
(select min(sal) from emp. Connect the empno port and min
(sal) port to exp. Fetch all the rows from emp table to
exp, then connect to filter give condition sal> min(sal).
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Is it possible to define a single node as a Gateway node as well as worker node?
EXL informatica Questions
what is Active lock explain
How are the sources and targets definitions imported in informatica designer?
explain abt ur project architecture?
What is the function of union transformation?
Explain about Informatica server process that how it works relates to mapping variables?
What is informatica worklet?
what is the -ve test case in your project.
What are the different clients of powercenter?
What is transformation?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
Can we create multiple integration service on single repository?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What do you mean by channel change?
