A variable defined in a parameter file cannot be used in a post-session command alone. It must be used along with other session properties like Output file directory or Source file directory for it to be used in the post-session command. Example Consider a variable $OutputFileRepSybase that is defined as /home/test in the parameter file. If this variable is used in a post-session command alone, as […]
Posts Tagged ‘analytics’
Healthcare Analytics Predicted to Grow to 50% in 4 years
Research for Frost & Sullivan shows only 10% of hospitals used health analytics tools in 2011. They further predict this to follow the increased investment in EHR technology to 50% by 2016. This is fueled by programs such as the HITECH Act where analytics are needed to justify and qualify for payments. My recent blog […]
How to restore a SQL Server 2008 R2 database backup to SQL Server 2008
Recently I got a backup file of a SQL Server 2008 R2 user database, and wanted to make a duplicate on to a SQL Server 2008 server instance.
A Silver Bullet for Big Data: Hadoop Family
In previous post I talked over basic concepts, business values, some situation and facts of big data application. Actually in current IT world, the big data related technologies and products were being developed and practiced dramatically. There will be a pretty long list in which how many companies and organizations have been involved in this […]
Video: SAP shows Real-Time Analytics in Motion with Big Data
This is a great video recently put out by SAP that covers real-time analytics with big data. Watch closely for some interesting figures, including that “the total amount of data will grow 50 times in the next 8 years.”:
Journey of CDC Configuration in Oracle Data Warehouse Admin Console
In most cases and requirements, the developers just need to make change in existing code repository of Informatica as well as DAC objects. However, when the requirement is brand new and there is no OOTB entity found, a new set of codes should be developed and DAC execution plan need to be setup. CDC stands […]
Big Data, Big Deal?
If we look back in recent years, the dominating words that represent technical trends are around “Cloud Computing” and “Big Data” in the IT world. More and more firms have planned strategically for big data as it is beyond a pure technical term and is gaining business impact. Per research published by Gartner, big data […]
Update RPT when Column Modified in Data Source
During the Crystal Reports development, it is very common data source (database, universe) definition modifications impact the fileds to be presented in the RPT, such as field renaming, data type changes, or even deletion of a specific data field. How can we synchronize the changes from the data source into RPT to make sure the […]
Use Arguments in Win 2008 Task Scheduler
Windows Server 2008 offers many more capabilities in Task Scheduler than the previous versions. Although these new capabilities are not exposed through the AT command, you can use the GUI console to access them. One of the useful capabilities is that you can add arguments when you choose starting a program. This option provides the […]
Placeholders in the CMC – Business Objects(II)
This is the second part of “Placeholders in the CMC – Business Objects”, please see the first part here 10. Placeholder List Table Placeholder Variables Name Variable Description Title %SI_NAME% Report title, it is same as report rpt name ID %SI_ID% InfoStore SI_ID value, System ID Owner %SI_OWNER% Report owner who schedules the report DateTime […]
Placeholders in the CMC – Business Objects(I)
Usually, after we finish developing a Crystal Report rpt with sufficient unit testing according to the report requirement, the next step is to upload it onto the CMC (Central Management Console) or InfoView server for scheduling. During the scheduling, we will be asked to walk through several steps (recurrence, schedule for, notification, database connection, filters, […]
Zoho CRM Adds Business Intelligence Reporting
ZOHO Corp. is best known for its Zoho suite of on-line business applications. The company was founded in 1996 and has been growing its offering of products since. While the Zoho CRM application has been in its latest version since last December, Zoho is now adding business intelligence reporting and analytics. This will include over […]