We are trying to convert Informatica tranformation into Teradata
In informatica we have the following transformation
iif (PK_COLUMN=PREV_PK_COLUMN_V,'N','Y') where they are comparing current row with previous row .
I want to know how to convert this to Teradata SQL
Also, PREV_PK_COLUMN_V is not an Informatica variable, so also state whats the source of this column.
This should translate to:
OVER (ORDER BY whatever
ROWS BETWEEN 1 PRECEDING END 1 PRECEDING)
Maybe you have to add a PARTITION BY, too.
Hi Dieter, I've tried to add the partition by but it always gives me an error. How would it look like with a partition by?