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

What the difference is between a database, a data warehouse and a data mart?

599


What is mapplet in informatica?

600


How do you load unique records into one target table and duplicate records into a different target table?

715


Different circumstance which drives informatica server to expel records?

557


What are the mapping parameters and mapping variables?

627






What is a repository? And how to add it in an informatica client?

668


Explain transaction control transformation in informatica

766


Could you explain what is enterprise data warehouse?

560


What are the differences between source qualifier and joiner transformation?

606


Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

6760


How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

631


Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

558


How do you take back up of repository?

727


How do you use reject loader.

2076


What are the informatica performance improvement tips

620