Interested to Buy Any Domain ? << Click Here >> for more details...
How to jion 2 tables, without using any condition?
- 11 Answers
- 37169 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
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What is Cognos script editor?
What are active transformations.
What is dynamic cache?
How to generate sequence numbers?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What are the different options available for update strategy?
Can we create a Integration service without a Repository service and vice versa?
What is the advantage of informatica?
Write the advantages of partitioning a session?
What are the new features of informatica 9.x at the developer level?
Enterprise data warehouse your projects phase by phase explain?
I have a flat file, want to reverse the contents of the flat file
Differentiate between Load Manager and DTM?
How to join three sources using joiner?
