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
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
In warehouses how many schemas are there?
Explain the code page compatibility?
how to load dimension table and fact table. plz tell me the steps.
How do you load first and last records into target table?
Explain in detail about scd type 1 through mapping.
Explain dynamic target flat file name generation in informatica
What is meant by lookup transformation? Explain the types of lookup transformation?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
How to elaborate powercenter integration service?
What is exclusive and normal mode for repository services?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
draw informatica architecture 8.6 ?
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?
What is the surrogate key?