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 do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1009


How does the aggregator transformation handle null values?

697


Which is the t/r that builts only single cache memory?

708


what is the size of your data warehousing?

1669


What is informatica? Why do we need it?

641






How can we store previous session logs?

567


What is sq transformation?

663


Tell me about Propagate functions in informatica

522


What is an unconnected transformation?

661


Different sorts of metadata that stores in the storage facility?

559


What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

789


What is an active transformation?

648


What is a transaction control transformation?

765


How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

634


what is informatica metadata?

599