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


Please Help Members By Posting Answers For Below Questions

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

630


In warehouses how many schemas are there?

583


Explain the code page compatibility?

641


how to load dimension table and fact table. plz tell me the steps.

1683


How do you load first and last records into target table?

664






Explain in detail about scd type 1 through mapping.

589


Explain dynamic target flat file name generation in informatica

648


What is meant by lookup transformation? Explain the types of lookup transformation?

567


is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

623


How to elaborate powercenter integration service?

648


What is exclusive and normal mode for repository services?

711


What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

7674


draw informatica architecture 8.6 ?

3468


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?

1320


What is the surrogate key?

636