Answer / guest

joining 2 tables with out conditon
select * from emp,dept;

emp having 10 rec
dept having 5 rec

out == 50 rec

Answer / kannan

when you assign key ={} these is called cartesian join

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.

What do you mean by the overflow errors?

0 Answers  

---

What is the difference between a utility and api in a RUN SQL component

1 Answers   Accenture,

---

How to Create Surrogate Key using Ab Initio?

6 Answers   IBM,

---

How to add default rules in transformer?

0 Answers  

---

I have $AI-SERIAL/DML------> (SERIAL FILE LOCATION) AND $BDS-SERIAL/DML---------->(what is the location what is mean)?

1 Answers  

---

---

Please some body send me Ab Initio material in my mail ... sitakanta2009@gmail.com Thanks in Advance!!!

1 Answers  

---

. How can you get all the fields form a lookup files ? (Which function)

3 Answers   TCL,

---

Layout - L1*, L1 - What is the difference ? How to use in abinitio graph?

1 Answers   IBM, TCL,

---

Is it possible to create a parameter in the component?

1 Answers  

---

What is dependent parameter ?

1 Answers   HCL,

---

What are the kinds of layouts does ab initio supports?

0 Answers  

---

what are the steps in actual ab initio graph processing including general,pre and post process settings?

2 Answers  

---