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 are the tuning techniques you applied during your last project

2073

What are the modules in Power Center

1718

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1130

What is session task and command task?

1392

How can we store previous session logs?

1139

What is pmcmd command?

1179

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

1210

What is the surrogate key?

1359

What is a joiner transformation?

1035

lookup transformation with screenshots

4048

Explain how many types of dimensions are available in informatica?

1169

What is meant by lookup transformation?

1180

How can we use mapping variables in informatica? Where do we use them?

1283

How many ways are there to create ports?

1402

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6282