Interested to Buy Any Domain ? << Click Here >> for more details...
How to jion 2 tables, without using any condition?
- 11 Answers
- 37652 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
What are data-driven sessions?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
Differentiate between source qualifier and filter transformation?
What are the different lookup cache(s)?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
How can we create index after completion of load process?
What is the need of etl tools?
Difference between Data and Index Caches?
What does role playing dimension mean?
How does a rank transform differ from aggregator transform functions max and min?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
can u give example for factless fact table
What do you understand by term role-playing dimension?
how many types of dimensions are available in informatica?
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?
