select * from emp where sal>(select min(sal) from emp) how to implement the

Categories >> Software >> Data Warehouse >> Informatica
Suggest New Category

select * from emp where sal>(select min(sal) from emp) how
to implement the same in informatica ?

Question Posted / cmanojkumar

5 Answers
8933 Views
Puma, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica..

Answer / 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

select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica..

Answer / 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

select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica..

Answer / cmanojkumar

Hi,
Thanks for your answer.
If we take this in single pipeline it will not allow us to
connect aggregator transformation and source qualifier
transformation to target transformation
Because we can't combine two active transformations to
another transformation.
I would like to know these rules. Can any on tell me why
can't we combine active and active ?

Is This Answer Correct ?

1 Yes

0 No

select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica..

Answer / rudra

SQualifier --> Sql Query -->select * from emp where sal>(select min(sal) from emp) -->Apply-->OK -->connect to TGT table (save it)
## Create wf and ssn then run it

Is This Answer Correct ?

0 Yes

0 No

select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica..

Answer / chiranjeevi.madam

The above answer is correct. But, the aggregated value should be found in one pipeline and the filter should be in another pipeline both coming from source qualifier or previous t/r.

Is This Answer Correct ?

0 Yes

2 No

Post New Answer