How to jion 2 tables, without using any condition?
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 are the transformations that are not supported in mapplet?
What is the fact table?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Explain the types of transformations?
What does “tail –f” command do and what is its use as an Informatica admin.
What is complex mapping?
What is target load order?
Explain the informatica workflow?
What is the sequence generator transformation in informatica?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What is an active transformation?
Repository user profiles
What is the need of etl tools?
How many number of sessions can one group in batches?