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
How you can differentiate between connected lookup and unconnected lookup?
Differentiate between reusable transformation and mapplet.
What are the types of schemas we have in data warehouse and what are the difference between them?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
how many types of dimensions are available in informatica?
How an expression transformation differs from aggregator transformation?
What are the transformations that are not supported in mapplet?
Can we create multiple integration service on single repository?
tell me about your project functionality
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is meant by active and passive transformation?
What are the issues you have faced in your project? How did you overcome those issues?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What are the advantages of using informatica as an etl tool over teradata?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?