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
- 8992 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
Differentiate between source qualifier and filter transformation?
what is the size of u r source(like file or table)?
What are the components of workflow manager?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What all join we can perform in LOOKUP transformation?
Define sessions in informatica etl?
What is status code in informatica?
Explain the aggregator transformation?
How to create the source and target database connections in server manager?
How to generate sequence numbers without using the sequence generator transformation?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Explain the difference between mapping parameter and mapping variable?
What are the settings that you use to configure the joiner transformation?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
write a query to retrieve the latest records from the table sorted by version(scd)
