What are set operators in Oracle

Answer Posted / parameswarareddy

UNION
UNION ALL
MINUS
INTERSECT

Is This Answer Correct ?    25 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can you differentiate between powercenter and power map?

619


What is mapplet in informatica?

588


how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1247


Can we get 1st record through Informatica(without sequence number).

974


Does an informatica transformation support only aggregate expressions?

602






I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1312


Different circumstance which drives informatica server to expel records?

549


How to update a particular record in target with out running whole workflow?

1149


What is the maplet?

616


What is lookup transformation?

585


What is the use of target designer?

602


How to convert multiple rows to single row (multiple columns) in informatica

888


What are the components of Informatica? And what is the purpose of each?

614


What is depict expression change?

610


How to join three sources using joiner? Explain though mapping flow.

689