How to jion 2 tables, without using any condition?
Answer Posted / jaimeen shah
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 ? | 24 Yes | 4 No |
Post New Answer View All Answers
How can you differentiate between powercenter and power map?
What is a sequence generator transformation?
How do you update the records with or without using update strategy?
what are the deliverables?in your project?
Explain load alternative records / rows into multiple targets - informatica
What is update strategy transform?
Explian the Process of deployment groups in informatica
How to delete duplicate row using informatica?
How do you manage the Parameter files while migrating your data from one environment to another environment?
Briefly define a session task?
What is repository manager?
What is union transformation in informatica?
Is there any target staging area in informatica not staging area
Explain why we use partitioning the session in informatica?
What is depict expression change?