How to jion 2 tables, without using any condition?
Answer Posted / kalyan
In SQL override (Source Qualifier level) write a query to
join the 2 tables like emp & dept as follows:
Select * from emp,dept;
The above query will return the cartesian product of the 2
tables; BTW, this don't have any condition...
Is This Answer Correct ? | 16 Yes | 2 No |
Post New Answer View All Answers
Under which circumstances, informatica server creates reject files?
Can we create multiple integration service on single repository?
What is a dimensional model?
Is stop and abort are same in informatica?
Quickly characterize reusable change?
What is meant by lookup transformation?
What are the advantages of informatica?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What are the components of Informatica? And what is the purpose of each?
What are ETL Tools?
Define joiner transformation?
which one is better performance wise joiner or look up
Where do we use mapping variables in informatica?
What do you mean by blocking transformation?
How will the document be delivered to me?