6-loading data separate by tilda (~) into a table using substr and instr function in Informatica 

Explore the power of SQL functions with our tutorial on using SUBSTR and INSTR in Informatica Intelligent Cloud Services. This video provides a practical guide to leveraging these essential SQL functions for data manipulation and transformation within your Informatica workflows.
What You Will Learn:
Introduction to SUBSTR and INSTR Functions: Understand the functionalities and applications of SUBSTR (substring) and INSTR (string search) functions in SQL.
Implementing SUBSTR: Learn how to extract substrings from data fields using the SUBSTR function.
Utilizing INSTR: Discover how to search for specific strings within data using the INSTR function.
Data Transformation Examples: Step-by-step demonstrations of using SUBSTR and INSTR functions to transform and manipulate data.
Optimization Techniques: Best practices for optimizing the performance and efficiency of SUBSTR and INSTR functions in SQL queries.
Integration with Informatica Cloud: Practical tips for integrating these functions seamlessly into Informatica Intelligent Cloud Services workflows.
loading data separate by tilda (~) into a table using substr and instr function in Informatica
Informatica Intellegent Cloud Services.
SELECT INFO,
SUBSTR(INFO, 1, INSTR(INFO,'~', 1,1)-1) AS ID,
SUBSTR(INFO, INSTR(INFO,'~', 1,1)+1, INSTR(INFO,'~', 1,2) - INSTR(INFO,'~', 1,1)-1 ) AS NAME,
SUBSTR(INFO, INSTR(INFO,'~', 1,2)+1, INSTR(INFO,'~', 1,3) - INSTR(INFO,'~', 1,2)-1 ) AS STATE,
SUBSTR(INFO, INSTR(INFO,'~',-1,1)+1) AS VIEWERS
FROM INFORMATION;