Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
中文
  • PowerCenter 10.5.7
  • 所有产品

目录

Search

  1. 前言
  2. 使用转换
  3. 汇总器转换
  4. 自定义转换
  5. 自定义转换函数
  6. 数据屏蔽转换
  7. 数据屏蔽示例
  8. 表达式转换
  9. 外部过程转换
  10. 筛选器转换
  11. HTTP 转换
  12. Identity Resolution 转换
  13. Java 转换
  14. Java 转换 API 引用
  15. Java 表达式
  16. Java 转换示例
  17. 联接器转换
  18. 查找转换
  19. 查找缓存
  20. 动态查找缓存
  21. 规范器转换
  22. 等级转换
  23. 路由器转换
  24. 序列生成器转换
  25. 排序器转换
  26. 源限定符转换
  27. SQL 转换
  28. 在映射中使用 SQL 转换
  29. 存储过程转换
  30. 事务控制转换
  31. 联合转换
  32. 非结构化数据转换
  33. 更新策略转换
  34. XML 转换

转换指南

转换指南

上一个 下一个

未缓存查找的 SQL 替代

未缓存查找的 SQL 替代

可以为未缓存查找定义 SQL 替代。集成服务不会从未缓存查找的替代语句中构建缓存。可以在替代 SELECT 语句中使用 SQL 函数。可以替代所有 SQL 查询，包括 WHERE 和 ORDER BY 子句。
当生成默认 SELECT 语句时，Designer 会根据查找条件生成 SELECT 语句，其中包含查找和输出端口以及 WHERE 子句。如果查找转换是未连接查找，则 SELECT 语句包含查找端口和返回端口。集成服务不会从您在查找转换的“条件”选项卡中配置的条件生成 WHERE 子句。
SELECT 查询中的每列使用别名定义输出列。请不要在 SQL 语句中更改此语法，否则查询会失败。要引用 WHERE 子句中的输入端口，请配置参数绑定。以下示例包括引用名称端口的 WHERE 子句： 
SELECT EMPLOYEE.NAME as NAME, max(EMPLOYEE.ID) as ID from EMPLOYEE WHERE EMPLOYEE.NAME=?NAME1?
未缓存查找的 SQL 编辑器在“端口”选项卡中显示输入端口和查找端口。
如果向 SQL 语句中添加函数，返回数据类型必须与 ALIAS 列的数据类型匹配。例如，ID 的数据类型与 MAX 函数的返回类型匹配： 
SELECT EMPLOYEE.NAME as NAME, MAX(EMPLOYEE.ID) as ID FROM EMPLOYEE
不能将 SQL 替代中的子查询用于未缓存的查找。