Interested to Buy Any Domain ? << Click Here >> for more details...
How to jion 2 tables, without using any condition?
- 11 Answers
- 37531 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
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Explain what are the different types of transformation available in informatica.
Describe expression transformation?
How many ways are there to create ports?
How to update or delete the rows in a target, which do not have key fields?
What is status code in informatica?
scenario where i can use only concurrent execution of workflow.
Why update strategy and union transformations are active?
Enlist the various types of transformations.
What is repository manager?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What is union transformation?
Explain pmcmd command usage in informatica
Write the unconnected lookup syntax and how to return more than one column.
