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
can anyone suggest best free Talend data integration training online
how to load dimension table and fact table. plz tell me the steps.
Explain the types of transformations?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Different qualification between a related rotate toward the sky and isolates look upward?
what is song in infrmatica...?
How to configure mapping in informatica?
Can we create two repositories on same database instance in oracle?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is the difference between STOP and ABORT options in Workflow Monitor?
what is the hint? how to use it to reduce the query processing in program?
Enlist some properties of sessions.
can we override a native sql query within informatica? Where do we do it?
What are the various types of transformation?
What are multi-group transformations?