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.

Is there any function in ab Initio which act like SCAN component

3 Answers  

---

Have you worked with packages?

0 Answers  

---

How Does MAXCORE works?

4 Answers   CTS,

---

What would be the next step after collecting the data?

0 Answers  

---

) Layout? What is the Dataset & Program Component Layout

2 Answers   TCL,

---

---

how will i can implement Insert a new record (if not present in Input file),Update the record (if present in input) a csv file in Abinitio

0 Answers  

---

What is the significance of ‘mp run’ command ?

1 Answers   TCL,

---

How you can test a dbc file ?

1 Answers   TCL,

---

When we should use 'jobid' for commit table (Output table component?? How to use in abinitio graph?

0 Answers   IBM, TCL,

---

Describe how you would ensure that database object definitions (tables, indices, constraints, triggers, users, logins, connection options, and server options etc)are consistent and repeatable between multiple database instances (i.e.: A test and production copy of a database)?

0 Answers  

---

. How can you run a graph continuously without using continuous components ?

3 Answers   TCL,

---

How to calculate total memory used my a graph?

1 Answers   IBM,

---