Hi Mahesh,
1) Concatenate :
concatenate appends the row of two tables into one, whether they have matching record or not.
let say.
load * Inline [
a, b
1,2
2,3
];
Concatenate load * Inline [
a, b
1,2
2,3
3,4
];
final table will have
a,b
1,2
2,3
1,2
2,3
3,4
2) Outer Join :
outer Join brings matching record as one record, and non matching from both tables
let say.
load * Inline [
a, b
1,2
2,3
7,8
];
outer Join load * Inline [
a, b
1,2
2,3
5,3
3,4
];
final table will have
a,b
1,2 (matching in both table so one record)
2,3 (matching in both table so one record)
7,8 (non matching from first table)
5,3 (non matching from second table)
3,4 (non matching from second table)
Hope it helps....
