Interested to Buy Any Domain ? << Click Here >> for more details...
What are Cartesian joins?
- 3 Answers
- 11385 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 |
If you check in one file twice in EME, one with a tag and second without a tag - Will the version number change ? How to use in abinitio graph?
What are the benefits of data processing according to you?
How data is processed and what are the fundamentals of this approach?
In Join component which record will go to unused port and which will go to reject port ?
We have file having country_name customer_name.For exp London Ram Bangalore Rohit London Shyam Bangalore Abhinav In output we need 2 files one file for london and second file for Bangalore.How to acheve this?
How do we extract data from client machine?
What is the default layout of a component ? Is it mandatory to set the layout of a component ?
What is conditional DML and Structured DML?
If m loading a file of 1 million records.and the graph fails after loading 10,000 records. In this case if we use rollback command then what will happen?
What is air-project parameter ?
What is data mapping and data modelling?
What are the functions of the replicate and dedup component?
Teradata 
