Interested to Buy Any Domain ? << Click Here >> for more details...
How to jion 2 tables, without using any condition?
- 11 Answers
- 37695 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 fact table? Explain the different kinds of facts.
Global and Local shortcuts. Advantages.
What are the modules in Power Center
what are the deliverables?in your project?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
Explain why we use partitioning the session in informatica?
How to extract sap data using informatica? What is abap? What are idocs?
Can we get 1st record through Informatica(without sequence number).
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is a filter transformation?
what is the complex transformation you used in informatica
What is a node in Informatica?
What is a filter transformation and why it is an active one?
How might you approve all mappings in the archive all the while?
What are the new features of Power Center 5.0?
