In a table, 4 person having same salary. How to get Third
person record only?
Answer Posted / rag
We can do this by adding the rownum pesudo coulmn in the sql
overrider and take the thrid one since all the values are same,
like select col1,col2,rownum
from tab1
where rownum=3
| Is This Answer Correct ? | 1 Yes | 21 No |
Post New Answer View All Answers
What is informatica etl tool?
how to create user defined function (udf) in informatica
Explain how to import oracle sequence into informatica?
What do you mean by blocking transformation?
How to differentiate between the active and passive transformations?
How you prepared reports for OLAP?
What is xml source qualifier transformation in informatica?
wf dont have integration severances how you can run?
What is Cognos script editor?
What are the transformations that are not supported in mapplet?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
According to his methodology what all you need before you build a datawarehouse
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
what are 3 tech challenges/ common issues you face?
What is InformaticaPowerCenter?