select * from emp where sal>(select min(sal) from emp) how
to implement the same in informatica ?
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
How would you copy the content of one repository to another repository?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What do you understand by a term domain?
What are the limitations of joiner transformation?
How many number of sessions can one group in batches?
How do you load first and last records into target table?
What is Index Caches size?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What is DR strategy for Informatica project?
Explain what is informatica metadata and where is it stored?
What is olap (on-line analytical processing?
In informatics server which files are created during the session rums?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What all are steps in up gradation of Informatica server?
Define the various join types of joiner transformation?