Preface
Introduction to PowerExchange for Google BigQuery
PowerExchange for Google BigQuery Configuration
- PowerExchange for Google BigQuery Configuration Overview
- Registering the PowerExchange for Google BigQuery Plug-in
  - Registering the PowerExchange for Google BigQuery Plug-in from the Administrator Tool
  - Registering the PowerExchange for Google BigQuery Plug-in from the Command Line Program
Google BigQuery Sources and Targets
Google BigQuery Mappings
- Google BigQuery Mappings Overview
- Source Filter
  - Configuring a Source Filter
Google BigQuery Sessions
Google BigQuery as CDC Target
Google BigQuery Pushdown Optimization
Appendix A: Google BigQuery Data Type Reference
- Data Type Reference Overview
- Google BigQuery and Transformation Data Types

PowerExchange for Google BigQuery User Guide for PowerCenter

10.5.9
- 10.5.8
- 10.5.7
- 10.5.6

Back Next

Pushdown Optimization Functions

When you use pushdown optimization, the PowerCenter Integration Service converts the expression in the transformation or workflow link by determining equivalent operators and functions in the database.

PowerExchange for Google BigQuery supports the following pushdown functions in a Google BigQuery database:

Function	Pushdown	Function	Pushdown	Function	Pushdown
ABORT()	-	INITCAP()	-	REG_MATCH()	-
ABS()	X	INSTR()	X	REG_REPLACE	-
ADD_TO_DATE()	X	IS_DATE()	X	REPLACECHR()	X
AES_DECRYPT()	-	IS_NUMBER()	-	REPLACESTR()	X
AES_ENCRYPT()	-	IS_SPACES()	-	REVERSE()	-
ASCII()	-	ISNULL()	X	ROUND(DATE)	X
AVG()	X	LAST()	-	ROUND(NUMBER)	X
CEIL()	X	LAST_DAY()	X	RPAD()	X
CHOOSE()	-	LEAST()	-	RTRIM()	X
CHR()	X	LENGTH()	X	SET_DATE_PART()	-
CHRCODE()	-	LN()	-	SIGN()	-
COMPRESS()	-	LOG()	-	SIN()	X
CONCAT()	X	LOOKUP	X	SINH()	-
COS()	X	LOWER()	X	SOUNDEX()	-
COSH()	-	LPAD()	X	SQRT()	X
COUNT()	X	LTRIM()	X	STDDEV()	-
CRC32()	-	MAKE_DATE_TIME()	-	SUBSTR()	X
CUME()	-	MAX()	X	SUM()	X
DATE_COMPARE()	X	MD5()	-	SYSDATE()	X
DATE_DIFF()	X	MEDIAN()	-	SYSTIMESTAMP()	X
DECODE()	X	METAPHONE()	-	TAN()	X
DECODE_BASE64()	-	MIN()	X	TANH()	-
DECOMPRESS()	-	MOD()	X	TO_BIGINT	X
ENCODE_BASE64()	-	MOVINGAVG()	-	TO_CHAR(DATE)	X
EXP()	X	MOVINGSUM()	-	TO_CHAR(NUMBER)	X
FIRST()	-	NPER()	-	TO_DATE()	X
FLOOR()	X	PERCENTILE()	-	TO_DECIMAL()	X
FV()	-	PMT()	-	TO_FLOAT()	X
GET_DATE_PART()	X	POWER()	X	TO_INTEGER()	X
GREATEST()	-	PV()	-	TRUNC(DATE)	X
IIF()	X	RAND()	-	TRUNC(NUMBER)	X
IN()	X	RATE()	-	UPPER()	X
INDEXOF()	-	REG_EXTRACT()	-	VARIANCE()	-

Columns marked with an X indicate that the PowerCenter Integration Service can push the function to the Google BigQuery database by using source-side or full pushdown optimization. Columns marked with a dash (-) symbol indicate that the PowerCenter Integration Service cannot push the function to the database.

Rename Saved Search

Table of Contents

PowerExchange for Google BigQuery User Guide for PowerCenter

PowerExchange for Google BigQuery User Guide for PowerCenter

Pushdown Optimization Functions

Pushdown Optimization Functions