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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

my source is junk data how will u remove that junk data by using unix please any one replay me

3239


Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

1502


What is a connected transformation?

672


What is the function of look up transformation?

645


3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

1750






Why do we need informatica?

552


How do you load only null records into target?

738


what is song in infrmatica...?

1671


How can you validate all mappings in the repository simultaneously?

752


What is meant by lookup transformation? Explain the types of lookup transformation?

565


Explain the tuning lookup transformation - informatica

607


Separate from a database, an information bazaar, and an information stockroom?

605


Explain load alternative records / rows into multiple targets - informatica

679


What is meant by LDAP users?

687


in reporting we add some new objects,how we get the count of the newly added objects to the report

1746