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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In informatica workflow manager, how many repositories can be created?

778


How do you remove duplicate records in informatica? And how many ways are there to do it?

711


Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

6748


What happens to map if we alter the datatypes between source and its corresponding source qualifier?

598


What is event and what are the tasks related to it?

612






What are the main issues while working with flat files as source and as targets ?

647


what is $$$$?

1734


Is it possible to use a client with different version than that of its Informatica server?

641


what are 3 tech challenges/ common issues you face?

1883


how to load dimension table and fact table. plz tell me the steps.

1682


Write the unconnected lookup syntax?

654


What is the fact table?

584


Tell me about Propagate functions in informatica

520


What is source qualifier transformation in informatica?

571


What are the mapping parameters and mapping variables?

619