How to jion 2 tables, without using any condition?

Answer Posted / rajesh

select * from emp natural join dept;

Is This Answer Correct ?    7 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many ways a relational source definition can be updated and what are they?

581


As union transformation gives UNION ALL output, how you will get the UNION output?

644


Explain the difference between mapping parameter and mapping variable?

606


What is primary and backup node?

698


What are junk dimensions?

634






I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

600


How would you copy the content of one repository to another repository?

557


can u any challenge your project?

1608


in reporting we add some new objects,how we get the count of the newly added objects to the report

1753


How to differentiate between the active and passive transformations?

625


On which transformations you created partitions in your project?

761


What are the performance considerations when working with aggregator transformation?

676


can anyone explain me about retail domain project in informatica?

7433


What is the advantage of informatica?

650


explain abt ur project architecture?

1765