UNION UNION ALL MINUS INTERSECT

What are set operators in Oracle

Question Posted / parameswarareddy

Answer Posted / parameswarareddy

UNION
UNION ALL
MINUS
INTERSECT

Is This Answer Correct ?

25 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is an expression transformation in informatica?

962

How to load the data from a flat file into the target where the source flat file name changes daily?

1003

Scheduling properties,whats the default (sequential)

1890

How can we use batches?

960

What are the informatica performance improvement tips

1016

Explain how many types of dimensions are available in informatica?

1006

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

1032

What is session task and command task?

1175

What are the different types of repositories created using informatica?

1059

How can we use mapping variables in informatica? Where do we use them?

1098

Explain about Informatica server process that how it works relates to mapping variables?

1006

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

2062

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8169

How do you set a varible in incremental aggregation

1825

can u give example for factless fact table

6441