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
- 8790 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
4 yrs etl devloper roles and responsibilities?any body give solutions
Explian the Process of deployment groups in informatica
What are the different types of repositories created using informatica?
Could you explain what is enterprise data warehouse?
what is the size of u r source(like file or table)?
How are the sources and targets definitions imported in informatica designer?
Differentiate between a repository server and a powerhouse?
r u done any partitions in ur project?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Explain in detail about scd type 1 through mapping.
what is SDLC way of code development?
Explain lookup transformation is active in informatica
What do you understand by SOA of Informatica?
Why is sorter an active transformation?
how to load rows into fact table in data warehouse
