Answer Posted / 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 |
Post New Answer View All Answers
How to run a graph infinitely?
What kind of layouts does abinitio support?
How to create a repository in abinitio for stand-alone system(local nt)?
What is the use of aggregation when we have rollup as we know rollup component in abinitio is used to summarize a group of data record? Then where we will use aggregation?
Whenever we load data into oracle table from staging table using exchange partition...then I read somewhere that data actually doesn't move in this and this command only reset the pointer in the data dictionary...so if data doesn't move then how data is loaded into the main table ? I mean wat is the point of pointer update in data dictionary?
How do you add default rules in transformer?
What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?
What is the difference between look-up file and look-up, with a relevant example?
How to insert/update a csv file by comparing it with another csv file? for example, i have 2 input files : ColA ColB ColC 1 A AA 2 B AB 3 C CC and second one : ColA ColB ColC 2 B BB 4 D DC Job should compare these 2 files and update the records present in first input file. so the output file will look like this: ColA ColB ColC 1 A AA 2 B BB 3 C CC 4 D DC
What is publickey and private key?what is the use of this two keys?
What is the function that transfers a string into a decimal?
What is the difference between sandbox and EME?
Given input file with single column having 1 2 2 4 3 .. Required output 1 2 2 4 4 4 4 3 3 3.. How?
What are differences between different versions of co-op?
Why do you think data processing is important?