In a table, 4 person having same salary. How to get Third
person record only?

Answer Posted / vaas

Hi pooja,

would rowid be 3?
can u use having clause in ur query?

pl let me know poojaa

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different clients of powercenter?

602


Explain the difference between mapping parameter and mapping variable?

606


WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1519


How to start a workflow using pmcmd command?

713


What is a node in Informatica?

627






What happens to map if we alter the datatypes between source and its corresponding source qualifier?

604


Where can we find the throughput option in informatica?

600


How can you increase the performance in joiner transformation?

711


Write the unconnected lookup syntax and how to return more than one column.

597


What is rank index in rank transformation?

606


Can u generate reports in Informatica?

658


Is it possible to use a client with different version than that of its Informatica server?

645


What is a connected transformation?

677


COM components can be used in Informatica

1875


Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1537