when we use lookup,if have 5 records,if i dont need 1st and
2nd records..what will be the procedure to achieve by using
lookup?/
Answer Posted / gurpreet
select from emp where rownum> 2;
se this in sql override
| Is This Answer Correct ? | 1 Yes | 9 No |
Post New Answer View All Answers
Please let me know how to make encryption and decryption with example?
Briefly describe lookup transformation?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
State the differences between sql override and lookup override?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
Clarify the aggregator change?
What is a dimensional model?
What is the difference between a repository server and a powerhouse?
Define joiner transformation?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
How can you increase the performance in joiner transformation?
Enlist some properties of sessions.
What is pmcmd command?
How we can create indexes after completing the loan process?
How to create or import flat file definition in to the warehouse designer?