Interested to Buy Any Domain ? << Click Here >> for more details...
select * from emp where sal>(select min(sal) from emp) how
to implement the same in informatica ?
- 5 Answers
- 9144 Views
- Puma, I also Faced
- E-Mail Answers
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
Which is the t/r that builts only single cache memory?
How can you differentiate between powercenter and power map?
How do you change a non-reusable transformation to reusable transformation?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
Under which circumstances, informatica server creates reject files?
What are active transformations.
can we override a native sql query within informatica? Where do we do it? How do we do it?
How to handle decimal places while importing a flatfile into informatica?
How do you handle two sessions in Informatica
What does cheating measurement mean?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What is the use of source qualifier?
How union transformation is used?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What are the types of schemas we have in data warehouse.
