Add Components Ref: https://help.talend.com/en-US/discovering-talend-studio/8.0/configuring-a-component
Category: Root
Feb 11
Talend: Configuring a tMap component join model
Source: •https://help.talend.com/en-US/joining-two-data-sources-tmap-talend-studio/8.0/tmap-inner-join
Feb 11
Exporting the results of a tMap component inner join: Rejected data to a new table
Steps: https://help.talend.com/en-US/joining-two-data-sources-tmap-talend-studio/8.0/displaying-results-tmap-joining?id=10
Feb 11
Talend: Configuring filters in a tMap component
Source: https://help.talend.com/en-US/joining-two-data-sources-tmap-talend-studio/7.3/tmap-filters-year
Feb 11
Installing Talend in MAC
Talend Open Studio for Data Integration. If you have intel based Mac, then the OSX installer will work. Else, you may install a Virtual Machine such as Parallels, then have Windows in it (Parallels may come with Windows), then have Talend under Windows Another option can be use Linux Versions. Download and install Download from: https://www.qlik.com/us/trial/talend-data-fabric …
Jan 30
Dynamic SQL
“Dynamic SQL is the SQL statement that is constructed and executed at runtime based on input parameters passed” Example: ChatGPT DECLARE @sql AS NVARCHAR(MAX) SET @sql = ‘SELECT * FROM Employees WHERE Department = ”’ + @department + ”” EXEC sp_executesql @sql Another Example: Oracle table_name := ‘HR.Employees’; dyn_sql := ‘Select * from ‘ || …
Jan 29
What is a Dynamic Cursor in Oracle PL/SQL
Dynamic/Ref Cursor CREATE OR REPLACE PROCEDURE query_invoice( month VARCHAR2, year VARCHAR2) IS TYPE cur_typ IS REF CURSOR; c cur_typ; query_str VARCHAR2(200); inv_num NUMBER; inv_cust VARCHAR2(20); inv_amt NUMBER;BEGIN query_str := ‘SELECT num, cust, amt FROM inv_’ || month ||’_’|| year || ‘ WHERE invnum = :id’; OPEN c FOR query_str USING inv_num; LOOP FETCH c INTO …
Jan 19
Case Statement in Oracle PL/SQL
Write a SQL block that will categorize Employee Salaries. If the Salary is higher than average, it will show ‘Above Average’ to the output. If the Salary is lower than the average it will show ‘Below average’ to the output. Use HR.Employees Table. Also, utilize CASE statement.
Jan 15
Variable Declaration Conventions in Oracle PL/SQL
Ref: https://trivadis.github.io/plsql-and-sql-coding-guidelines/v4.1/2-naming-conventions/naming-conventions/
