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
Describe an informatica powercenter?
How to improve the performance of a session using sorter transformation?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
How many ways are there to do 'remove duplicate records in informatica'?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
How do you manage the Parameter files while migrating your data from one environment to another environment?
How many number of sessions can one group in batches?
What is complex mapping?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Where do we use mapping variables in informatica?
pmscmd startworkflow -sv
How to delete duplicate row using informatica?
What you know about transaction control transformation?
How to elaborate powercenter integration service?
Global and Local shortcuts. Advantages.