Problem Description: Nowadays ETL developers facing the issue with data redundancy while dealing with large data sets. As part of the storage concern, we need to reduce the duplicate data from daily incoming source data and load the latest data to the target table. Challenges to Developer/user Basically, the source data come along with timestamp filed by using that timestamp field we need to extract the data which is newly coming newly and load it to the target. Make use of parameters or variables in the Informatica power center Understanding the value precedence of parameters and variables. Make use of :setmaxvariable() function in expression transformation.

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.