How To Export Data Using Select Query In MYSQL
Introduction Exporting data using a SELECT query in MySQL is a common practice to extract specific data from a database and save it in a usable format. This allows users…
Read MoreHow To Generate Dynamic Numbers in MYSQL
Introduction: Generating dynamic numbers in MySQL involves creating a sequence of numbers or generating numbers dynamically in queries. This is useful in various scenarios, such as creating IDs, generating row…
Read MoreHow To Insert Data from One Database into Another Database Using Apache Nifi
Introduction: – In modern data management, transferring data between different databases is a common requirement. Apache NiFi, an open-source data integration tool, provides a powerful and flexible solution for this…
Read MoreHow to Install Apache Kafka in Windows
1. Overview This document talks about how to install Apache Kafka for windows. [Note: Steps included in this document will only works windows server] 2. Technologies and Tools Used The…
Read MoreHow to Install Apache Nifi in Windows
1. Overview This document talks about how to install Apache Nifi for windows. [Note: Steps included in this document will only works windows server] 2. Technologies and Tools Used The…
Read MoreCustomer Account Import Error Query – FBDI
The below query extracts the error details along with interface attributes of Customer Account import using FBDI in Fusion Applications. SELECT distinct err.message_name ERROR_MESSAGE ,msg.message_text MESSAGE_TEXT ,acc.* FROM hz_imp_errors err…
Read MoreOracle Fusion HCM Data Loader (HDL) Keys Significance
HCM Data Loader (HDL) Keys Supported Key Types: HCM Data Loader (HDL) supports 4 different types of keys as listed below GUID – Oracle Fusion Global Unique ID Oracle Fusion…
Read More