How to jion 2 tables, without using any condition?
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 IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What is difference between a gateway node and worker node?
What is domain and gateway node?
What is parallel processing in informatica?
What are the differences between joiner transformation and source qualifier transformation?
What is sorter transformation?
Clarify the utilization of aggregator cache record?
What is a grid in Informatica?
What are Dimensional table?
Which are the different editions of informatica powercenter that are available?
Repository user profiles
Where are the source flat files kept before running the session?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
How to start a workflow using pmcmd command?
How to do the error handling of if ur source is flatfiles?