March 11, 2019

PC to Cloud utility In Informatica!

Problem Description Customers/Users/Developers face road gap issues sometimes while developing the new mapping code in the cloud environment which they already designed and developed in the Informatica power centre mapping. Challenges to User/Developer In IICS, the above-mentioned problem can be solved through PC to Cloud Conversion. PC to Cloud Conversion reads PowerCenter export XML files, analyzes the PowerCenter objects for reusability in Data Integration, and converts the objects to assets in the Data Integration repository. After the objects are converted, you can publish them so that you can use them in Data Integration.
March 1, 2019

Indirect loading for flat files of Informatica PowerCenter!

PROBLEM DESCRIPTION: Suppose from each country we are getting the Customers data in a separate file. These files have the same structure and same properties and we want to load all these files in to a single target. Creating a mapping for each source file will be tedious process. Informatica provides an easy option (indirect load) to handle this type of scenarios. Challenges to user/developer: In Informatica power center, the indirect source file type option is used to load the data from multiple sources files that have the same structure and properties. The integration service reads each file sequentially and then loads the data into target. The process involved in specifying the indirect load are Creating a list file and , Configuring the file properties in session.
March 1, 2019

Informatica Cloud File Processor Connector

Problem Description- Several times a user would want to upload and download files from the remote machine to a local machine using FTP/SFTP. As to transfer files from the Protocol system the user needs privileges along with a proper connector to transfer a file from the Informatica platform to another system or vice versa.
February 18, 2019

Randomization In Informatica Cloud (IDMC)

Problem Description Customers/Users face issues in picking multiple CSV files with having the same base name from a directory and generates multiple Excel file for each CSV file. The Excel files need to be generated based upon either percentage of available filtered records or exact number of records and maximum records allowed in a single excel file. The filtration of records is based upon the specific column and its specific value.
February 18, 2019

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.
February 18, 2019

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.
January 21, 2019

How To Case Comments in Case Object Without The Public Checkbox in Salesforce?

Problem Description: Salesforce users/customers have an issue with Case Comments(Internal comments) as it shows up for all users. Challenges to User/Developer: A workaround is to create a custom object which replicates the behavior of the standard Case Comments object.
January 21, 2019

Challenges on Multi Select While Reporting in Salesforce!

Problem Description: Salesforce doesn’t allow users to create a report based on an individual multi-picklist field or group the reports based on individual multi picklist. Challenges to User/Developer : A workaround for this is to create a custom object which holds the multi-picklist values of the object you are trying to build a report on.
January 21, 2019

Unable To Set a Record Type in Salesforce Object in Salesforce Community

Problem Description : Salesforce users/customers have issues with seeing record types in community page. Solution : If all the page layouts and permissions are assigned correctly and yet there is no record type shown in the community. Then, contact the Salesforce customer support and make sure it is enabled from their end.