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
What do you understand by SOA of Informatica?
Can we create multiple integration service on single repository?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What are the different transaction levels available in transaction control transformation?
What are Dimensional table?
How to partition the Session?
What is the Rank index port in Rank transformation?
What is the difference between a repository server and a powerhouse?
What is meant by query override?
As union transformation gives UNION ALL output, how you will get the UNION output?
Suppose we do not group by on any ports of the aggregator what will be the output?
What is the function of aggregator transformation?
How to update a particular record in target with out running whole workflow?
what is the size ur source like(file system or database)? how many record daily come u r banking project?