Skip to content

Explore Informatica

Extract – Transform & Load

  • Home
  • PowerCenter
  • BDM
  • Unix/Linux
  • Vue Js
  • YouTube
  • Contact me

Tag: Informatica

Pushdown optimization in informatica PowerCenter

August 8, 2020August 9, 2020 by kvt - Comment is Closed

This article will help you to understand Pushdown Optimization technique to enhance Informatica ETL performance. We will see how to implement Pushdown optimization and its limitation. Author: Dhandhaliya Dhiraj Informatica […]

Read More

Informatica services stops automatically

August 9, 2016April 16, 2020 by kvt - Comment is Closed

Informatica Services are Getting Stop Automatically All of a sudden i couldn’t connect to Repository, I am getting an error. Usually this error comes if the Informatica service is not […]

Read More

Informatica certification – Transformations

March 1, 2016August 9, 2020 by kvt - Comment is Closed

Working with Transformations – My Notes — Transformation Overview —  Which is the repository object that generates, modifies, or passes data? Ans:- A Transformation. Which transformation performs calculations on groups […]

Read More

Informatica certification – Lookup Transformation

February 24, 2016August 9, 2020 by kvt - Comment is Closed

Lookup Transformation – My Notes What is Lookup transformation? Ans:- It can be used to look up data in a flat file, relational table, source Qualifier, view, or synonym. What […]

Read More

How to load every 5th record into target table

February 19, 2016August 9, 2020 by kvt - Leave a Comment

How to load every 5th record into target table We need to read the source table and load only 1st and every 5th (nth) records to target. Let’s start the […]

Read More

How to remove duplicate records using Expression

February 18, 2016August 9, 2020 by kvt - Leave a Comment

How to remove duplicate records using Expression In the last post we have used Aggregator Transformation to remove the duplicate records. In this post we will use the Expression transformation […]

Read More

Informatica Certification – My Notes

February 10, 2016April 16, 2020 by kvt - Comment is Closed

The below question and answers are my preparation notes for Informatica Developer Specialist certification which I am planning to take some time in June. I will continue update this page as i […]

Read More

Informatica Certification Developer Specialist

February 9, 2016April 16, 2020 by kvt - Comment is Closed

PowerCenter Data Integration 9.x: Developer, Specialist Certification This is Skill set Inventory document from Oracle website. Here you will get all the information which is required for the Informatica certification […]

Read More

Informatica Target Load Plan

February 7, 2016August 9, 2020 by kvt - Comment is Closed

Target Load Group and Target Load Plan   If you have multiple Source Qualifier transformations connected to multiple targets, you can specify the order in which  the Integration Service loads the data […]

Read More

How to Load only Half of the records from Source table

February 3, 2016August 9, 2020 by kvt - Leave a Comment

Load only Half of the records from Source table The requirement is to process only half of the records from the source table. To do this we need to calculate the […]

Read More

How to fix [Informatica][ODBC Oracle Wire Protocol Driver] Optional feature not implemented

February 2, 2016August 9, 2020 by kvt - Leave a Comment

[Informatica][ODBC Oracle Wire Protocol Driver] Optional feature not implemented You may get this error while trying to Preview data on Target in a Mapping Designer. I have also seen the […]

Read More

Source Qualifier – Full Outer Join

December 30, 2015August 9, 2020 by kvt - Comment is Closed

Full Outer Join using Source Qualifier – ‘SQL Query’ Integration service support only Left & Right outer joins. We cannot perform Full outer join using ‘User Defined Join’ properties in […]

Read More

Source Qualifier – User Defined Join – Right Outer Join

December 29, 2015August 9, 2020 by kvt - Comment is Closed

How to join two tables – Source Qualifier – User Defined Join – Right Outer ** Source Qualifier Transformation is the most efficient way to join two tables in the same Database […]

Read More

Source Qualifier – User Defined Join – Left Outer Join

December 29, 2015August 9, 2020 by kvt - Comment is Closed

How to join two tables – Source Qualifier – User Defined Join – Left Outer ** Source Qualifier Transformation is the most efficient way to join two tables in the same Database […]

Read More

Source Qualifier – User Defined Join – Normal Join

December 29, 2015August 9, 2020 by kvt - Comment is Closed

How to join two tables – Source Qualifier – User Defined Join ** Source Qualifier Transformation is the most efficient way to join two tables in the same Database ** There are […]

Read More

Posts pagination

1 2 3

Subscribe Channel

Follow in FB

Facebook

Categories

  • IBM Mainframe (1)
  • Informatica (186)
    • ETL Jobs in USA (70)
    • Informatica – Whats New? (2)
    • Informatica BDM (21)
    • Informatica Cloud (4)
    • Informatica PowerCenter (52)
    • Informatica Trainings (6)
    • Performance Tuning (3)
    • PowerCenter Certification (20)
    • PowerCenter Installation (2)
    • PowerCenter Interview Questions (1)
    • Shell Scripting (8)
    • Troubleshoot (5)
    • YouTube Videos (6)
  • Vue Js (5)

Recent Posts

  • How to Sign up Microsoft Power Apps without business or work email
  • How to extract middle name in Informatica Power center
  • How to extract first & last name in Informatica Power center
  • Build a real time web application using Vue.js, MySql, Php, Firebase and Google cloud
  • How to calculate Age in informatica power center

Tags

Advanced Workflow Aggregator BDM Automation Certification Developer Tools ETL Jobs Expression Filter Transformation Flat FIles Full Outer Join Functions Informatica Informatica BDM Informatica Certification Informatica Cloud Informatica Jobs Informatica trainings Informatica Webinar Installation jobs Joiner Lookup Mapping Normal Join Oracle Connections Performance Tuning powerCenter PowerCenter Certification PowerCenter Express Rank Repositories Sequence Generator Sessions Sorter Transformations Source Qualifier Target Connections Transformations Transformations-Lab Troubleshoot Unix Shell Scripting in BDM Update Strategy Transformation Vue js workflow Workflow Manager Working Tips
© Explore Informatica
Go to mobile version