Excel to CSV using SFTP In IICS
February 18, 2019Randomization In Informatica Cloud (IDMC)
February 18, 2019Problem Description of CSV Splitting In Informatica cloud
Easily split your CSV In Informatica cloud: 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
Easily split your CSV files in IICS
- In IICS, the 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 another location.
Solution
CSV Splitting In Informatica Intelligent Cloud Services (IICS)
Approach
Easily split your CSV Using Java Transformation, we can achieve the solution for the above-mentioned challenges.
Java transformation is used to add custom integration logic into mappings using a built-in developer-friendly editor or by plugging in custom JAR files.
Technical Solution –
- Develop Java code that performs CSV split based upon some specific column and specific value of that column using IDE(ex. Eclipse)
- Create an Executable jar file for the above-developed java code.
- Place the above-created jar file at any directory at the local machine (where the security agent is installed).
- Copy the above directory path including the jar name with extension.
- Create the CLASSPATH Environment variable if not available.
- Paste the above-copied directory to the CLASSPATH Environmental variable.
- Restart the secure agent.
- Create the mapping using source and target with java transformation in between them.
- Edit java transformation to make a call to the specific method of the class available in a jar which is responsible for splitting the CSV file into multiple CSV files based upon some specific column and column value.
- Compile the above java code, validate the mapping and run.
Advantage –
The CSV file will get split into multiple CSV files based upon some specific column and specific value of that column.
Issues –
None
Conclusion –
So, the CSV file will be split based on the column provided by the user.