Interested to Buy Any Domain ? << Click Here >> for more details...
How to jion 2 tables, without using any condition?
- 11 Answers
- 37698 Views
- Amazon, I also Faced
- E-Mail Answers
Answer Posted / manjula
it is not possible to actually join two tables without
using any condition.
if U would like to join two tables, then in source
qualifier transformation add all the port from two tables (
if both tables are from same database source) and write
down your join condition in user defined join option or
otherwise write down join condition inside the sql query
option with generated sql query.
if u use two different database source then use joiner to
join the two tables
| Is This Answer Correct ? | 2 Yes | 2 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?
What are the different types of olap? Give an example?
Which are the different editions of informatica powercenter that are available?
What does reusable transformation mean?
Does an informatica transformation support only aggregate expressions?
How many ways are there to do 'remove duplicate records in informatica'?
How can we remove the duplicates from flat file source?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Difference between Target-based loading and constraint-based loading?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What is depict expression change?
What are multi-group transformations?
What is informatica? Why do we need it?
write a query to retrieve the latest records from the table sorted by version(scd)
COM components can be used in Informatica
