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
my source is junk data how will u remove that junk data by using unix please any one replay me
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?
What is a connected transformation?
What is the function of look up transformation?
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
Why do we need informatica?
How do you load only null records into target?
what is song in infrmatica...?
How can you validate all mappings in the repository simultaneously?
What is meant by lookup transformation? Explain the types of lookup transformation?
Explain the tuning lookup transformation - informatica
Separate from a database, an information bazaar, and an information stockroom?
Explain load alternative records / rows into multiple targets - informatica
What is meant by LDAP users?
in reporting we add some new objects,how we get the count of the newly added objects to the report