Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i am loading tab1: AC and Tab2: AC what is the result? and what about duplicate values? please explain
If both the tables have same name and number of columns autoconcatenation happens so if table 1 has 20 rows and table 2 has 20 rows. Your rowcount will be 40. What is that you are looking for?
If both the tables have same name and number of columns autoconcatenation happens so if table 1 has 20 rows and table 2 has 20 rows. Your rowcount will be 40. What is that you are looking for?
thank you for your response mr. viswanath,
for example if both tables have only one column name is same then what is the result? can you please explain
Then autoconcatenation doesnot happen a relationship if formed with a joining key on this common column. You can see two different tables with a joining key on similar column.