Interested to Buy Any Domain ? << Click Here >> for more details...
How to jion 2 tables, without using any condition?
- 11 Answers
- 37739 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
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Why update strategy and union transformations are active? Explain with examples.
What are the informatica performance improvement tips
What is session task and command task?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
what are the Methods For Creating Reusable Transformations?
Explain the different kinds of facts.
What is flashback table ? Advance thanks
Enlist the advantages of informatica.
Differentiate between source qualifier and filter transformation?
What is a repository manager?
What is depict expression change?
Performance tuning( what you did in performance tuning)
Mention few advantages of router transformation over filter transformation.
Differences between connected and unconnected lookup?
