simply use a dummy condition like 1=1. This works :)

How to jion 2 tables, without using any condition?

Question Posted / bittu sarkar

Answer Posted / bittu sarkar

simply use a dummy condition like 1=1.
This works :)

Is This Answer Correct ?

8 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is joiner transformation in informatica?

623

Define filter transformation?

619

What is the function of look up transformation?

645

 Informatica Checkpoints

2851

How do you load only null records into target?

736

Explain what are the different types of transformation available in informatica.

567

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1493

explan ur project architecture?

1587

How to call shell scripts from informatica?

570

Explain the different lookup methods used in informatica?

581

Enlist the tasks for which source qualifier transformation is used.

582

Explain how many types of dimensions are available in informatica?

590

Explain lookup transformation source types in informatica

694

Explian the Process of deployment groups in informatica

651

What are the main features of Oracle 8i with context to datawarehouse?

1677