Interested to Buy Any Domain ? << Click Here >> for more details...
How to jion 2 tables, without using any condition?
- 11 Answers
- 37645 Views
- Amazon, I also Faced
- E-Mail Answers
Answer Posted / chetan sharma
use natural join.
it automatically takes column from the both of table that are equal via column name and their datatype.
example:> two table employee,department and one field is
common b/w these two table and this is dept_no then
"select * from employee natural join department" will automatically retrieve the those rows from the both table that have the same dept_no.........
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the procedure for creating independent data marts from informatica 7.1?
How are the sources and targets definitions imported in informatica designer?
How to elaborate powercenter integration service?
I have a flat file, want to reverse the contents of the flat file
What is workflow? What are the components of workflow manager?
What is informatica?
Is it possible to use a client with different version than that of its Informatica server?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Explain why we use partitioning the session in informatica?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Why is sorter an active transformation?
Explain in detail about scd type 1 through mapping.
Write the prerequisite tasks to achieve the session partition?
Make a note of the quantity vaults made in informatica?
How we can use union transformation?
