In a table, 4 person having same salary. How to get Third
person record only?
Answer Posted / pooja
hi all,
suppose 4 emp geting same sal as 4000... select * from emp
where sal=4000 and/having rowid=3
| Is This Answer Correct ? | 0 Yes | 14 No |
Post New Answer View All Answers
Clarify the aggregator change?
What is joiner transformation in informatica?
Explain pushdown optimization $pushdownconfig parameter - informatica
What is an active transformation?
What do you mean incremental aggregation?
What do you mean by worklet?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What is the way to execute pl/sql script using informatica mapping?
Define pmcmd command?
What are the settings that you use to configure the joiner transformation?
What are the types of data warehouses?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What will be the approach?
What is a code page?