Answer Posted / riman bhaumik
its not like --with out condition...
TABLE 1 Table 2
X Y X Z
a e a j
b f a k
c g i m
Resultant Join over field X
X Y Z
a e j
a e k
This is an example of Cartesian joins.
| Is This Answer Correct ? | 3 Yes | 6 No |
Post New Answer View All Answers
Why might the optimizer use a table scan when an index is available?
How abinitio eme is segregated?
What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?what are differences between different versions of co-op?
What kind of layouts does abinitio support?
What are the various types of layout supported by abinitio?
What is the max core of a component?
What do you mean by the overflow errors?
What is is a data flow graph?
What is a look-up?
When running a stored procedure definition script how would you guarantee the definition could be rolled back in the event of problems?
Describe in detail about lookup?
Explain the difference between the truncate and delete commands?
How do you add default rules in the transformer?
Mention what is abinitio?
How do you add default rules in transformer?