getGrpBy() Method

Usage

public java.lang.String getGrpBy()

Description

Allows you to retrieve the SQL GROUP BY string (on the "source" during the collect phase, on the staging area during the integration phase). This statement is automatically computed from the aggregation transformations detected in the mapping expressions. 

Parameters

None

Example

insert into <%=odiRef.getTable("L", "COLL_NAME", "W")%>
select <%=odiRef.getColList("", "[EXPRESSION]", ", ", "", "INS=1")%>
from <%=odiRef.getFrom()%>
where (1=1)
<%=odiRef.getJoin()%>
<%=odiRef.getFilter()%>
<%=odiRef.getGrpBy()%>
<%=odiRef.getHaving()%>