CODEWITHSUNDEEP
etlinformaticainformatica-powercenter
John G
John G

Reputation: 23

Cross join in Informatica

I have a query that I need translated into Informatica

SELECT COL1, COL2, COL3 FROM TABLE1
CROSS JOIN
(SELECT MAX(COL3) FROM TABLE1)

In Informatica I have a Source going to a joiner to get COL1 and COL2 and an aggregator coming out of the same source to get the MAX(COL3). However, when I use a JOINER to connect them, I cannot. What is the appropriate way of doing this?

Upvotes: 0

Views: 1380

Answers (2)

Bilal Zeaiter
Bilal Zeaiter

Reputation: 1

You can do it using SQL-override:

SELECT max(col3) over () as max_col3, COL1, COL2, COL3 FROM TABLE1

Upvotes: 0

Ruchi
Ruchi

Reputation: 679

For joining same source pipelines you need to select "input is sorted" in the joiner properties.

Upvotes: 2

Related Questions