Interested to Buy Any Domain ? << Click Here >> for more details...
How to jion 2 tables, without using any condition?
- 11 Answers
- 37502 Views
- Amazon, I also Faced
- E-Mail Answers
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
What does update strategy mean, and what are the different option of it?
What is the need of etl tools?
How to delete duplicate row using informatica?
which one is better performance wise joiner or look up
Explain the types of transformations?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What all join we can perform in LOOKUP transformation?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
Explain the features of connected and unconnected lookup.
Explain constraint based loading in informatica
What is the use of an aggregator cache file?
design of staging area?
What is aggregator transformation in informatica?
Can anyone tell me the new features in Informatica 9 Version?
What are the types of schemas we have in data warehouse.
