In a table, 4 person having same salary. How to get Third
person record only?
Answer Posted / divesh chasta
informatica solution :
first we will create seq and then filter out the third
record by this condition mod(id%3)=0
from this we can get third record.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the reusable transformations?
How to use pmcmd utility command?
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,
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
what are the deliverables?in your project?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
How to differentiate between the active and passive transformations?
Differentiate between Load Manager and DTM?
What is an active transformation?
Make a note of the quantity vaults made in informatica?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What is native users?
Does an informatica transformation support only aggregate expressions?
How to update or delete the rows in a target, which do not have key fields?
Which is the t/r that builts only single cache memory?