Ref: https://docs.oracle.com/database/121/LNPLS/create_procedure.htm#LNPLS01373
Category: Root
Mar 26
What are some Data Integration Tools?
Tools for data integration, ETL (Extract, Transform, Load), and data management. 1. Apache NiFi 2. Pentaho Data Integration (PDI) 3. Apache Spark 4. Microsoft SQL Server Integration Services (SSIS) 5. Informatica PowerCenter 6. Apache Airflow 7. Matillion 8. Fivetran 9. Stitch 10. Apache Camel 11. Luigi 12. SnapLogic 13. DataStage (IBM) Ref: Internet
Mar 14
Oracle CASE within SELECT
From: https://docs.oracle.com/cd/B19306_01/server.102/b14200/expressions004.htm Syntax: Example: Write a SQL block that will categorize Customers’ Credit Limit. If the limit is > 5000, show high, when 100 show low otherwise show medium. Utilize CASE statement. SELECT cust_last_name, CASE credit_limit WHEN 100 THEN ‘Low’ WHEN 5000 THEN ‘High’ ELSE ‘Medium’ END FROM customers; CUST_LAST_NAME CASECR ——————– —— … Bogart …
Mar 14
Oracle ISOLATION Levels
Isolation => I in ACID Supported two types: However, there are other levels of ISOLATION such as: Read Uncommitted Repeated READ — Note: in Read Committed, dirty data is locked until committed. In Repeated Read, A row (being modified) is locked until committed. In Serializable, A block/dataset/table (being modified) is locked until Serialization Terminated. TCL/Transaction …
Feb 27
ChatGPT Prompt Engineering Concepts
Provide Context Provide Delimeters Use Detailed Instructions Refactor Prompts Let ChatGPT ask questions for clarifications Split complex Tasks Use Custom Settings (you can keep the context in the custom settings) : Use multi-modality (voice, image) Socratic Prompting Use Dall-E 3 “DALL·E 3 is built natively on ChatGPT, which lets you use ChatGPT as a brainstorming …
Feb 24
Requirements Management Software
From: https://thedigitalprojectmanager.com/ “10 Best Requirements Management Tools Shortlist Here’s my pick of the 10 best software from the 18 tools reviewed. From ChatGPT: “Here’s a list of the most advanced tools for managing business requirements in software development jobs. These tools focus on capturing, managing, and collaborating on business requirements efficiently: 1. Jira 2. Confluence …
Feb 11
Talend Open Studio: How to Start Guide
How to Get Started with Talend Open Studio for Data Integration Source: https://www.talend.com/resources/get-started-talend-open-studio-data-integration
Feb 11
Talend Studio: Learn Data Integration Tasks
•Joining two data sources with the tMap component in Talend Studio •Creating a Talend Studio project •Creating a Job to join data sources •Data joining using the tMap component •Configuring joins in the tMap component •Configuring filters in a tMap component
Feb 11
Talend Open Studio: Tutorials
Advanced Tutorials: • Configuring Joins in tMap • Adding Condition-Based Filters Using the tMap Component • Using Context Variables • Writing and Reading Data in HDFS
