CTS – Your Technology Partner

Informatica PowerCenter: Indirect File Source

Written by Kaiesha Ford on June 30, 2014

In the Informatica PowerCenter, there are two ways to load a flat file into a Target definition: Direct and Indirect. You can set the Source File type to ‘Direct’ when loading a single flat file. ‘Indirect’ Source File type is when you need to load multiple flat files. When implementing the ‘Indirect’ file type, users…

Continue Reading


SQL Server 2014 – Columnstore Indexes

Written by Kathleen Kennedy on June 27, 2014

The columnstore index, a feature in SQL Server’s Database Engine, received updates and a major addition in SQL Server 2014. Columnstore indexes debuted in SQL Server 2012 as a solution for slow data warehouse queries. What is a columnstore index? A columnstore index is a technique for storing, retrieving, and managing table data that is…

Continue Reading


SharePoint Information Management Policies

Written by Kenny Gordon on June 16, 2014

Manage your content with out of the box features. Most users and some IT professionals are not aware of the Information Management Policy (IMP) features that are included as a standard SharePoint feature. IMPs allow us to configure various aspects of the content stored in our farm…such as (maybe Retention, Auditing, etc.) An administrator can…

Continue Reading