How to jion 2 tables, without using any condition?
Answer Posted / bittu sarkar
simply use a dummy condition like 1=1.
This works :)
| Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
When do you use sql override in a lookup transformation?
What is a predefined event?
tell me about your project functionality
Different sorts of metadata that stores in the storage facility?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
How can informatica be used for an organization?
What are the different components of powercenter?
How do we call shell scripts from informatica?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
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?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
Differentiate between joiner and lookup transformation?
Have you worked with/created Parameter file
What is blocking transformation?
what is song in infrmatica...?