February 18, 2019
Informatica Cloud
Categories

CSV Splitting In Informatica cloud platform (IICS)

Problem Description Customers/Users face issues in splitting a CSV file into multiple CSV based upon some specific column and its specific value of that column. Challenges to User/Developer In IICS, above mentioned problem can be solved through Java Transformation. The CSV file needs to be split into multiple CSV files. Move the original CSV file to other location.
Do you like it?0
Read more
February 18, 2019
Excel to CSV using SFTP In IICS
Categories

Excel to CSV using SFTP In IICS

Problem Description Customers/Users face issues with loading Excel files from SFTP remote server to local machine and convert the excel file to CSV file in mapping on IICS. Challenges to User/Developer In IICS, above-mentioned problem can be solved through Java Transformation. The Excel file needs to be transferred to the local machine (where the secure agent is installed). The locally available Excel file needs to be converted to CSV file. Move the original Excel file which we got from SFTP remote server to other location.
Do you like it?0
Read more