Answer Posted / srikanth
select * from table where rownum<=30
minus
select * from table where rownum<=21;
| Is This Answer Correct ? | 13 Yes | 2 No |
Post New Answer View All Answers
What is domain and gateway node?
What are the modules in Power Center
How to extract sap data using informatica?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
what are the deliverables?in your project?
Did u used latest transformations of 8.6.0? for what?
Where can we find the throughput option in informatica?
How many ways are there to do 'remove duplicate records in informatica'?
What is informatica powercenter repository?
What is union transformation?
What are Dimensional table?
How might one distinguish in the case of mapping is right or not without associating session?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What is the difference between a repository server and a powerhouse?