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
English
  • Data Integration Connectors
  • All Products

Table of Contents

Search

  1. Abstract
  2. Connectors Released for April 2024
  3. Adabas CDC Connector
  4. Adabas Connector
  5. Amazon DynamoDB V2 Connector
  6. Amazon Redshift V2 Connector
  7. Business 360 Connector
  8. Business 360 FEP Connector
  9. Databricks Delta Connector
  10. Datacom CDC Connector
  11. Datacom Connector
  12. Db2 for i CDC Connector
  13. Db2 for i Connector
  14. Db2 for LUW CDC Connector
  15. Db2 for z/OS CDC Connector
  16. Db2 for z/OS Connector
  17. Google BigQuery V2 Connector
  18. IBM MQ Connector
  19. IDMS CDC Connector
  20. IDMS Connector
  21. IMS CDC Connector
  22. IMS Connector
  23. Kafka Connector
  24. Microsoft Azure Data Lake Storage Gen2 Connector
  25. Microsoft Fabric Data Warehouse Connector
  26. Microsoft Fabric Lakehouse Connector
  27. Microsoft Fabric OneLake Connector
  28. Microsoft SQL Server CDC Connector
  29. MySQL CDC Connector
  30. Oracle CDC V2 Connector
  31. PostgreSQL CDC Connector
  32. SAP HANA CDC Connector
  33. Sequential File Connector
  34. Snowflake Data Cloud Connector
  35. VSAM CDC Connector
  36. VSAM Connector
  37. Informatica Global Customer Support

Connector Release Notes

Connector Release Notes

Back Next

Databricks Delta Connector

Databricks Delta Connector

Fixed issues

The following table describes fixed issues:
CR
Description
CCON-92957
When you use IIF() function with ISDATE() function in a Databricks Delta mapping enabled for SQL ELT optimization, the mappings fails with the following error:
java.lang.ClassCastException: org.apache.spark.sql.execution.datasources.v2.DataSourceV2Relation cannot be cast to org.apache.spark.sql.execution.datasources.LogicalRelation
(February 2024)
CCON-92943
When you run a Databricks Delta mapping enabled for SQL ELT optimization, the IIF() function returns incorrect results in the following cases:
  • IIF() function is used with LAST_DAY(), ISNULL(), or SUBSTR() functions.
  • IIF() function is used with IS_NUMBER() and the input value is NULL, empty string, or white spaces.
  • IIF() function is used with IS_SPACES() and the input value is an empty string.
(February 2024)
CCON-94189
When you read Timestamp values from a source and write to a Databricks Delta target, the Timestamp values are preserved only up to millisecond precision of three digits in the target. (February 2024)
CCON-57945
When you push down an IIF() function in a mapping that reads from and writes to Databricks Delta, and the Boolean values are returned as 0 and 1, the mapping fails. When the Boolean values are true and false, the mapping runs successfully. (December 2023)
CCON-70460
When you configure a Databricks Delta connection using the personal staging environment and run two mappings concurrently to write two different parquet files to a target folder, the mappings fail with the following error:
[Error In Running Sql Query: [Simba][SparkJDBCDriver](500051) ERROR processing query/statement. Error Code: 0, SQL state: org.apache.hive.service.cli.HiveSQLException: Error running query: [_LEGACY_ERROR_TEMP_2332] org.apache.spark.sql.AnalysisException: [UNABLE_TO_INFER_SCHEMA] Unable to infer schema for Parquet.
(November 2023)

Known issues

The following table describes known issues:
Issue
Description
CCON-92977
When you use an unconnected lookup and run a Databricks Delta mapping enabled for SQL ELT optimization, the mapping fails if you use Nested IIF() function or if the IIF() function returns a Float value in the lookup query. (December 2023)
CBDM-29892
A mapping that reads from or writes decimal data types in hierarchical data fails with the following error:
java.lang.RuntimeException
(July 2023)
0 COMMENTS
We’d like to hear from you!