Nashville SQL Server User Group

Announcements

Meeting Information

Monthly Meetings

Our regular monthly meetings occur on the last Friday of each month from 11:30 AM - 1:00 PM. Lunch is served during the first half hour and the scheduled session begins at noon. We meet at The Microsoft Heartland Office which is located at

The Microsoft Heartland Office
8 City Blvd, Suite 403
Nashville, TN 37209
Phone: (615) 778-2500
Fax: (615) 778-2510      

Next Meeting: Mon, Feb 27 2017

February Meeting: Arvind Kumar

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: https://www.eventbrite.com/e/nashville-pass-meeting-tickets-32338519382

SQLSERVER – INFORMATICA : PUSHDOWN OPTIMIZATION

Summary:

One of the limitation of ETL approach is I/O between DB server and ETL server back and forth. This has significant impact on the performance. PUSHDOWN optimization provide the approach to use ETL tool with its strength and database engine power appropriately as needed and avoid unnecessary I/O between DB and ETL server.

 

About the Speaker:

Leader in building Information Management architecture, to enable business driven data analytics. Over 20 year of IT experience with 15+ years working as Data warehouse/Data Integration architect and 8+ years as leader in Information Management.

Currently I am IT Principal and Director of Information Management and ODS (Operational Data Store) in cigna-healthspring, leading the effort to streamline the integration and analytical architecture by creating integration pattern using Informatica, SQL Server, Teradata and Cloudera Hadoop cluster . As next level, also building the business analytical environment to support predictive analysis and enable business partner to make more informed decision.

In past, lead the ETL COE team of DNB (Dun & Bradstreet) and key contributor in Wirpo Technologies Data Warehouse COE team to achieve reusability, cost reduction and performance improvement in the Data integration and Data Warehouse environment.

Master in Data Science
Graduated from Indian Institute of Technology India,

Our Sponsor:

Since 2001 Rezult Group has been a full service I.T. recruiting firm specialized in placing highly sought after resources in Contract / Contract to Perm / Permanent positions throughout the greater Nashville area. Our strength lies in our ability to connect local talent with local companies by forging strong relationships with the area’s top talent and top employers. We are committed to partnering and supporting the local technology community to help drive Nashville to be one of the nation’s premiere technology hubs.

 

When

iCal
UTC : Mon, Feb 27 2017 17:30 - 19:00
Event Time : Mon, Feb 27 2017 11:30 - 13:00 (UTC-06:00) Central Time (US & Canada)
Your Local Time: Mon, Feb 27 2017 17:30 - 19:00

Where

8 City Blvd
Nashville, Tennessee

Direction: None

Attachments

Offers

 

Exclusive Offers for User Group Members

Oreilly Book Discounts

 Thanks to Oreilly for providing us books to give away and providing a discount code for our users. Buy ebooks at 50% off and print books at 40% off: When you purchase a book or ebook on oreilly.com use the UG Program discount code: DSUG

 

Great Microsoft Learning Offers

Microsoft Learning has released a collection of valuable offers for the PASS user group community. Get the Microsoft Learning products that you want for less. Take advantage today of these special offers for home and office users, IT professionals, and developers by visiting: www.microsoft.com/learning/offers

 

Carry all your tech books with you anytime with one-click reference on Microsoft technologies

Microsoft Press has developed a virtual library for IT Professionals, developers and information workers who want to learn about Microsoft products and related technologies. And we want to share it with the Microsoft user group members. To learn more about the E-Reference Library, please click here (http://www.microsoft.com/learning/books/ereference/default.mspx).

 

 

 

sql_micro_sm.gif 

SIOS 

 

 

 

 

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids