Category: Oracle Reports

Balance Groups in Oracle Fusion HCM

Balance Groups in HCM are amounts or hours that are aggregated based on Month, Quarter or Year. Balance Group and Balance Group Usages for the specific Balances can be created from the Payroll Calculation work area in the Oracle Fusion HCM environment. Oracle HCM Fusion provides us the option of using either Pre-defined balance groups or User-defined custom balance groups for our reports. Pre-defined Balance groups in HCM contain information about all the earnings and deductions but if we would like to see only the amounts or hours of a list of earnings. User-defined custom balance group can be created with the list of earnings that we require and use it in our custom extract to view only the values for those earnings. Data Terrain with years of experience and reliable experts is ready to assist. We have served more than 200 plus customers in the US and an additional 60 plus customers worldwide. We are flexible in working hours and do not need any long-term binding contracts.

Read More +

Guidelines to create Key Ranges in Informatica

Informatica

The key range partitioning in Informatica distributes rows of data based on a port or set of ports that you define as the partition key. Guidelines to create key ranges are mentioned below. ● The partition key must contain at least one port. ● The range for each port in the partition key should be specified. ● The Informatica PowerCenter standard date format can be used to enter dates in key ranges. ● The workflow manager does not validate overlapping string, numeric ranges, the gaps, or missing ranges. When you define key range partitioning at a source qualifier transformation, the Informatica Integration Service defaults to pass-through partitioning if you change the SQL statement in the Source Qualifier transformation. If a row contains a null value in any column or falls outside of the key ranges then the integration service sends that row to the first partition. DataTerrain, with years of experience and reliable experts, is ready to assist. We have served more than 250 customers in the US and over 70 customers worldwide. We are flexible in working hours and do not need any long-term binding contracts.

Read More +

Overview of Active and Idle Databases in Informatica

informatica

In pushdown optimization the Informatica Integration Service pushes the transformation logic to a database called active database and when it does not process then it is called idle database. ● When using full optimization in Informatica the target database will be active whereas the source database will be idle. ● In sessions which contain lookup transformation the source or target database is active whereas the lookup database will be idle. ● In sessions which contain joiner transformation in Informatica the source in the detail pipeline is active whereas the source in the master pipeline is idle. ● In a session which contains Union transformation the source in the first input group is active whereas the source in other input groups will be idle. DataTerrain, with years of experience and reliable experts, is ready to assist. We have served more than 250 customers in the US and over 70 customers worldwide. We are flexible in working hours and do not need any long-term binding contracts.

Read More +