Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

without matching columns in two tables. how can you join

Answer Posted / ankit kansal

Its against the concept of Normalization to join two tables without PK and FK relationship. however if you try to join both tables then it will return you Cartesian product.
lets say your first of your table contains = 12 rows and
the other one also contains 12 rows then net output will be 144 rows.

http://deepinopensource.blogspot.in/

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different ways to implement parallel processing in informatica?

1479


How to handle decimal places while importing a flatfile into informatica?

1240


What are the differences between a connected lookup and unconnected lookup?

1124


Explain target update override in informatica

1189


How do you load alternate records into different tables through mapping flow?

1926


Can u generate reports in Informatica?

1143


how many types of dimensions are available in informatica?

1177


Explain lookup transformation is active in informatica

1147


what is the size ur source like(file system or database)? how many record daily come u r banking project?

2192


Which development components of informatica have the highest usage?

1098


Design a mapping to load the cumulative sum of salaries of employees into target table?

1554


Explain in detail about scd type 1 through mapping.

1628


Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

2071


How is union transformation utilized?

1059


permutations of mapplet

2548