Interested to Buy Any Domain ? << Click Here >> for more details...
What are Cartesian joins?
- 3 Answers
- 11645 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
joining 2 tables with out conditon
select * from emp,dept;
emp having 10 rec
dept having 5 rec
out == 50 rec
| Is This Answer Correct ? | 12 Yes | 3 No |
Answer / kannan
when you assign key ={} these is called cartesian join
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
What do you mean by the term data warehousing?
What do you mean by the term data warehousing? Is it different from data mining?
Explain what does dependency analysis mean in abinitio?
What is meant by Co > Operating system and why it is special for Ab-initio ?
State the working process of decimal_strip function?
How many parallelisms are in Abinitio?
How to move or copy the project parameter or project object to my sandbox?
What exactly do you understand with the term data processing and businesses can trust this approach?
Explain what is de-partition in abinitio?
Input A 100 NUll A NUll 200 B 100 Null B Null 300 Output A 100 200 B 100 300 Do this using Ab initio
can any one help me now i am learning AB Inito but i don't have material and pdf's can any one provide pdf's to this mail id mohanraju0113@gmail.com thanks in advance...................................
Can someone tell me the behaviour of next_in_sequence() and innovation_number() in a multifile. Suppose I have records 1,1,1,2,2,3,4,4 in a 4ways mfs file. Data in each partition is: 0th : 1,1,1 1st : 2,2 3rd : 3 4th : 4,4 What will be the sequence of these records if I pass next_in_sequence() and innovation_number() ? Also how can I extract 3rd record from each of the 4 partitions of a 4way multifile through AbInitio? In unix we can use m_dump
Teradata 
