In a table, 4 person having same salary. How to get Third
person record only?
Answer Posted / mr.lee
id sal
101 1000
102 1000
103 1000
104 1000
Select Rn, id, Sal, From (
Select Rownum Rn, id ,Sal From Emp)
Where Rn = 3
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What is the Rank index port in Rank transformation?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
in reporting we add some new objects,how we get the count of the newly added objects to the report
What are the types of presistent cache in look up tr.
waht type of interface is used for testing the data in informatica
In how many ways we can create ports?
Plz can any one say me how to get the informatica certification materials and dumps
What is the scenario which compels informatica server to reject files?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Why update strategy and union transformations are active?
Explain the mapping variable usage example in informatica
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.