Cross join in Informatica

0
votes

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?

2
etlinformaticainformatica-powercenter

2 Answers

2
votes

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

0
votes

You can do it using SQL-override:

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