Interested to Buy Any Domain ? << Click Here >> for more details...
How to jion 2 tables, without using any condition?
- 11 Answers
- 37185 Views
- Amazon, I also Faced
- E-Mail Answers
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
generate date / time dimension in informatica
What is the use of an aggregator cache file?
What is DR strategy for Informatica project?
Explain how many types of dimensions are available in informatica?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What are multi-group transformations?
what is size of u r database?
What is mapping debugger?
What does reusable transformation mean?
How does the aggregator transformation handle null values?
what is $$$$?
what is Active lock explain
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What differs when we choose the sorted input for aggregator transformation?
Write the program through which the records can be updated?
