วีดีโอ

How many ways to get TOP N in SQL using EMP Table

Weekly Revenue, Derive Week start date and end date for every sales date, consider week_start_date as Sunday's date and week_end_date as Saturday's date.

tFileList: helps you to Iterate a set of files or folders in a given directory based on a filemask pattern

Talend tUniqRow component is used to remove duplicate records from a data flow. The component receives input from another component and can then remove duplicates based on "Key" attribute(s). The tUniqRow component can also reroute all duplicate rows to a different output flow.

Talend tunite component can be used to combine data from multiple sources or tables.

SQL Working Session Task 8: Write a SQL Query that allows you to get product & month wise Revenue, Last year Revenue, Last Month Revenue, Last Quarter Revenue.

SQL Working Session Task 7:Write a SQL Query that allows you to get Customer Active Date, Active age in months, Latest Active date etc, by making use of Sales data

SQL Working Session Task 6: Query that allows you to get product & year wise Revenue, Last year Revenue, YOY difference & YOY %

Query that allows you to get product-wise Revenue, Quantity, Average unit Sell Price, Latest sell price.

Write SQL Query that allows you to get monthly product-wise sales (Revenue), includes Year-to-Month sales (Revenue) as separate columns.

Query that allows you to get monthly product-wise sales (Revenue), includes Year-to-Month sales (Revenue) as separate column.

Task Description:Query that allows you to get monthly product-wise sales, with each month as a separate column, includes Year-to-Date sales and Last Year-to-Date sales as separate columns. Refer the following sample data.

Improve your SQL skills with this task! Write a SQL query to get the top 10 customers, show the remaining customers in the 11th row, and display the grand total revenue in the last row. Don't miss out on this opportunity to sharpen your SQL and Oracle knowledge.

Talend Java Components Part1 (tjava, tjavarow)

Talend Java Components Part2 (tjava, tjavarow)

Talend context Variables

Talend tmap Joins PART 3 (Snowflake data load)

Talend tmap Component PART 2 (Snowflake database) - Dynamic Variable value

Talend tmap Component PART 1(Snowflake database)

Snowflake Self register (How to start Snowflake Trial Account)

Talend Studio overview

XML File to Snowflake table using Talend

JSON File to Snowflake using Talend

Talend CSV File to Snowflake Table (tfileinputdelimited)

Talend tLogRow component (Logs & Errors)

What is Data Analytics Tools

Talend Job for Oracle to Snowflake data load

Talend Cloud setup, Download Talend Studio

OBIEE RPD Session1