Informatica, Oracle, Netezza, Unix Tutorials and Examples

Cumulative Sum Calculation in Informatica

2013-05-21T01:51:00.000-07:00

Q) How to find the cumulative sum of salaries of employees in informatica? I have employees table as a source. The data in the employees table is shown below: Table name: employees Dept_Id,...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Informatica PowerCenter Repository - Global and Local

2013-05-20T01:08:00.003-07:00

Informatica powercenter repository is used to store the metadata information and it resides in a relational database. The repository stores information required to extract, transform, and load data....

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Command Task in Informatica

2013-05-13T04:46:00.001-07:00

Command task in informatica is used to run the shell / unix commands during the workflow. You can specify unix commands in the command task to remove rejected files, ftp files, creating files etc. We...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Different Types of Tracing Levels In Informatica

2013-05-09T03:58:00.002-07:00

The tracing levels can be configured at the transformation And/OR session level in informatica. There are 4 different types of tracing levels. The different types of tracing levels are listed...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

SCD type 4 - Fast growing dimension

2013-05-01T01:53:00.002-07:00

In normal scenarios the dimension tables tend to grow slowly. That is the reason, they are called slowly changing dimensions. Example: Location attribute of a customer changes very rarely. However...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Informatica Training in Bangalore

2013-04-25T04:07:00.002-07:00

We have started informatica training institue in bangalore. The course details are: Data Warehousing Course Contents Data Ware housing Concepts: Introduction to Data Warehousing Introduction to...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Configure Email on Unix - Informatica

2013-04-18T04:04:00.001-07:00

We use the email task in informatica for sending emails whenever the workflow fails or succeeds or for any other cause. The email task uses the rmail command in unix operating system for sending...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Unconnected Stored Procedure Transformation Example - Informatica

2013-04-17T02:59:00.001-07:00

This is continuation to my previous post on connected stored procedure transformation example. Here I am going to use the same stored procedure which was used in the connected stored procedure...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Stored Procedure Transformation Example In Informatica

2013-04-16T05:02:00.003-07:00

In this article, we will see how to create a connected stored procedure transformation using a simple example. Example: Lets consider the employees table in the oracle database as the source. We...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Stored Procedure Transformation in Informatica

2013-04-15T01:46:00.000-07:00

Stored Procedure Transformation is a passive transformation. Stored procedure transformation can be used in both connected and unconnected mode. Stored procedures are stored and run within the...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Convert multiple Rows to single row (multiple Columns) in Informatica

2013-04-03T23:17:00.000-07:00

I have the sales table as a source. The sales table contains the sales information of products for each year and month. The data in the source table is shown below: Source Data: Sales table year...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Cursor For Loop Example in Oracle PlSql

2013-04-03T01:22:00.002-07:00

Cursors provide easy way to fetch records from database table(s) and store them in memory for future use. The following steps are followed when fetching rows from the cursor: Open the...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Create Deployment Group in Informatica

2013-03-26T00:52:00.000-07:00

In informatica, there are two types of deployment groups. They are: Static Deployment Group: You have to add objects manually. Create static deployment group when the objects in the group are not...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Deployment Groups in Informatica

2013-03-18T02:57:00.002-07:00

Deployment group is a global object which consists of objects from one or more folders. Deployment group is used to copy objects from one or more folders to another folder or repository. You can...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

How / Where to Download Informatica PowerCenter Software

2013-03-10T06:36:00.000-07:00

You can download informatica powercenter software from the oracle website. Just follow the below steps for downloading the informatica power center suite from the oracle site: Open the site...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Unix Sed Command to Delete Lines in File - 15 Examples

2013-03-07T22:53:00.000-08:00

In this article we will see how to delete or remove specific lines that contains a pattern or in a particular position in a file. As an example, consider the below file with sample data: > cat...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Learn / Practice Mysql, Oracle SQL Online - Tool

2013-03-07T03:14:00.002-08:00

I have come across a beautiful online tool which is very useful for learning or practicing SQL queries online without the need for installing a database. SQLFiddle is the website which provides the...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Load Last N Records of File into Target Table - Informatica

2013-03-06T06:06:00.002-08:00

Q) How to load only the last N rows from source file into the target table using the mapping in informatica? First take a look at the below data in the source...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Load Alternative Records / Rows into Multiple Targets - Informatica

2013-03-05T07:52:00.004-08:00

Q) How to load records alternativly into multiple targets in informatica? Implement mapping logic for this. I have a source file which contains N number of records. I want to load the source...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Dense Rank function In Mysql SQL Query (Create / Implement)

2013-03-04T06:28:00.002-08:00

How to calculate the grouped dense rank function in mysql sql queries? Mysql database does not have the built-in support for dense rank functionality. Databases like oracle, Netezza supports the...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Rank function In Mysql SQL Query (Create / Implement)

2013-03-04T06:15:00.003-08:00

How to calculate the grouped rank function in mysql sql queries? Mysql database does not have the built-in rank functionality. Other databases like oracle, Netezza supports the rank analytical...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Row Number function In Mysql SQL Query (Create / Implement)

2013-03-04T06:01:00.002-08:00

How to calculate the row number function in mysql sql queries? Mysql database does not have the built-in row number functionality. Other databases like oracle, supports the row number analytical...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Scheduling Options of Informatica ETL tool workflows / Jobs

2013-02-18T01:26:00.005-08:00

Informatica ETL tool has a buit-in scheduler, which is used to schedule the workflows or jobs to run at specified time intervals. There are other tools like autosys available in the market for...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Informatica Real Time Project - Part 1

2013-02-15T01:28:00.003-08:00

Here I am going to provide only a part of the project which I felt a bit complex in implementing. The project is about cabs data warehouse. Let me expalin the problem first and then we see how to...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

How to recover lost root user password in Unix /linux

2013-02-13T01:22:00.000-08:00

Creating a complex password is a very important issue in our life. So that no one hacks our password. The more complex is the password, the safer our account. However by creating a complex password,...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]