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

Under what condition selecting sorted input in aggregator may fail the session?

1108

What are the uses of etl tools?

1108

Briefly explain the aggregator transformation?

983

How can informatica be used for an organization?

1192

What is lookup transformation?

1021

State the differences between sql override and lookup override?

1173

Explain the pipeline partition with real time example?

1121

How many ways are there to create ports?

1306

How to start a workflow using pmcmd command?

1223

How can you increase the performance in joiner transformation?

1181

How many transformations can be used in mapplets.

1908

What is the meaning of up gradation of repository?

1954

How do you remove duplicate records in informatica? And how many ways are there to do it?

1151

is it possible to index the data in cache of lkp transformation ?

2014

Tell me about Propagate functions in informatica

911