Category: Informatica

Webinar – Transform Customer Experience by Maximizing Your Salesforce Investments – Aug 29

Do you struggle with data silos as you continue to expand your Salesforce footprint to multiple orgs, clouds and multi-cloud, hybrid application architecture? Join our upcoming webinar on understanding and engaging the customer throughout your digital transformation. This interactive webinar will show how Genomic Health and Carbonite have used Informatica Intelligent Cloud Services to capitalize on… Continue reading Webinar – Transform Customer Experience by Maximizing Your Salesforce Investments – Aug 29

Informatica ETL Developer–Rochester, NY

Greetings, Hope you are doing good, kindly go through the job description below and let me know your interest, I apologize if the job is not of your interest, however I will highly appreciate if you can refer somebody suitable for this position. **Please share your updated resume so that I can assist well in… Continue reading Informatica ETL Developer–Rochester, NY

ETL Informatica Developer in Pittsburgh, PA

Hello, My name is Gaurav and I’m a recruiter at IDC Technologies, Inc., a global staffing and IT consulting company. We are constantly on the lookout for professionals to fulfil the staffing needs of our clients and we currently have a job opening that fits your resume perfectly. Below is a summary of the position.… Continue reading ETL Informatica Developer in Pittsburgh, PA

ETL Informatica Developer in Minneapolis, MN

Hope you are doing well.   Kindly go through the below role and let me know your interest regarding the same.   ETL Informatica Developer in Minneapolis, MN NOTE: Looking for the candidates who can work on W2 Skills Required: • Interpreting and analyzing business requirements and converting them into high and low-level designs. • Designing and… Continue reading ETL Informatica Developer in Minneapolis, MN

Informatica Developer // Charlotte, NC

Hope you are doing well, Kindly find the below position and let me know if you are interested Job Title:: Informatica Developer Location : Charlotte, NC Fulltime Permanent Position Interview Type: Phone & Skype Visa Independent Consultant ( Like GC EAD ,GC, USC citizen) Job Description :- • This position is responsible for providing Informatica… Continue reading Informatica Developer // Charlotte, NC

Informatica Developer – Hoboken – New Jersey

My name is Pankaj and I’m an IT recruiter at IDC Technologies and have opening for Informatica Developer with one of my client. Please check below detailed Job Description and let me know if you would like to discuss more about this . You can reach me at 408-457-9381- Ext-4102 Title: Informatica Developer Location: Hoboken… Continue reading Informatica Developer – Hoboken – New Jersey

ETL Developer with Mongo DB::::Richmond VA

Dear Business Associates, Hope you are doing great. We have a urgent requirement of ETL Developer with Mongo DB for the location of Richmond VA Job Title:ETL Developer with Mongo DB Location:Richmond VA Duration:Long Term Required Skills:- · Mongo DB · ETL · Informatica Mail to: karunesh@noralogic.com

XML Transformations

XML Transformations in Informatica What are the different types of XML transformations? Ans:- XML Source Qualifier Transformation, XML Parser Transformation and XML Generator Transformation. What is XML Source Qualifier transformation? Ans:- It defines the data elements that the integration service reads from a XML source definition. XML Source Qualifier transformation is an​ ​…….​ ​transformation? Ans:-… Continue reading XML Transformations

Stored Procedure transformation​ in Informatica​

​Stored ​Procedure A stored procedure is a precompiled collection of Transact-SQL, PL-SQL or other database procedural statements and optional flow control statements, similar to an executable script. Stored procedures are used to automate tasks that are too complicated for standard SQL statements. Stored procedures are stored and run within the database. The stored procedure must… Continue reading Stored Procedure transformation​ in Informatica​

Solution – Create Retail Datamart using Informatica PowerCenter

Certification Project – Create Retail Datamart using Informatica PowerCenter Problem Statement. The purpose of this solution is to explain how to create a retail data warehouse / Datamart using PowerCenter. Description: Transaction and master data from OLTP (online transaction processing) systems is loaded into the data warehouse as Fact tables and Dimension tables respectively. In… Continue reading Solution – Create Retail Datamart using Informatica PowerCenter

Performance Tuning – Aggregator Transformations

Aggregator transformations often slow performance because they must group data before processing it. Aggregator transformations need additional memory to hold intermediate group results. Use the following guidelines to optimize the performance of an Aggregator transformation: Group by simple columns. Use sorted input. Use incremental aggregation. Filter data before you aggregate it. Limit port connections. Grouping… Continue reading Performance Tuning – Aggregator Transformations

Informatica certification – Commit Points

What is source based commit? Ans:- The Integration Service commits data to the target based on the number of rows from some active sources in a target load order group. What is One-to-One  mapping? Ans:- One-to-one mapping is a mapping that moves data from a Source Qualifier, XML Source Qualifier, or Application Source Qualifier transformation directly… Continue reading Informatica certification – Commit Points

Source Based Commits

  The Integration Service commits data to the target based on the number of rows from some active sources in a target load order group. When the Integration Service runs a source-based commit session, it identifies commit source for each pipeline in the mapping. The Integration Service writes the name of the transformation used for… Continue reading Source Based Commits