Badges
55 Points
9 Years
User Activity
Almost 9 years ago
GaryM, I understand that automatic refresh can cause data mapping errors, but identifying the changes, notifying the users and letting the user decide how to apply the changes (update, ignore, create a copy of mapping and edit ...). When the object in DB changes, chances…
Almost 9 years ago
Answered a question: When evaluating NoSQL Databases, what aspect do you think is the most important to look for?
With any DB, ETL plays a significant role. Being an ETL person, for me, NoSQL DB's compatibility with BI/ETL tools and it's connectivity matters most
Secondly NoSQL requires very good programming skills unless a GUI interface can be used to maneuver around the DB, so the…
Almost 9 years ago
Answered a question: When evaluating Reporting Software, what aspect do you think is the most important to look for?
Apart from speed with which the data reflects the changes applied to DB, when you make a selection on the report, data related to only that particular selection should reflect in subsequent tabs or applications. For example: if i choose a product on products tab, it's sales…
About 9 years ago
Hello Joop
Thank you for your comment. Unfortunately Informatica integration service does not interact with DB to pick up live feeds. So, anytime Insert/Update/Delete occurs on a DB object, it's corresponding definition in Informatica needs to be refreshed manually…
About 9 years ago
Contributed a review of Informatica PowerCenter: It can work with any kind of database, including NoSQL ones, but when a database object changes then object definitions do not get refreshed automatically.
Over 9 years ago
Contributed a review of Toad Data Modeler: It allows reusable queries for faster debugging, but it doesn't allow creating multiple pipes in one integrated workflow.
Reviews
About 9 years ago
Informatica PowerCenter
Over 9 years ago
Toad Data Modeler
Answers
Almost 9 years ago
NoSQL Databases
Almost 9 years ago
Reporting
Comments
About me
Tech Lead with expertise in areas of Business Intelligence and Data Warehousing. Demonstrated experience utilizing ETL Tools like Informatica, SAP BODS, SSIS and Data Probe, Informatica as my primary tool of expertise. Strong Leadership experience mentoring interns, providing in-house training and managing/leading technical groups on BI/ETL standards and best practices.
Professional Developments: Trained with SAP on BODS and Trained with Truven Health on Data Probe.
Efficient in SQL Scripts and flexible with different Operating Systems.
Extensively used TOAD , Oracle Developer , SQL Navigator, i-Series Navigator, SQL Showcase Query 7.0 and i-series Emulator for Data Modelling, Data Analysis, Data Manipulation and Data Profiling.
Specialties::
Languages : C, C++, SQL, XML.
ETL tools : Informatica versions 7.1, 8.1, 8.6, 9.1, SAP BODS 3.x, SSIS, Power Exchange 8.X, Truven Health Data Probe.
Database : Oracle 9i/10g/11g, DB2 AS 400, SQL Server 2008, XML, Cobol/VSAM, Flat Files, mongoDB.
Database Tools : TOAD, Oracle Developer, Qlik View, Showcase Query, i-Series Nav and Emulator.
Systems : Windows 98/2000/XP/Vista, UNIX (Sun Solaris), MS-DOS.