Recent Posts

4 Ways to Remove M Characters “Control M” or “^M” or “CTRL M” Characters in a UNIX file

September 8, 2012 5:50 pm4 comments
4 Ways to Remove M Characters “Control M” or “^M” or “CTRL M” Characters in a UNIX file

Remove M Characters “Control M” or “^M” in UNIX file. It can be achieved by 4 ways though my vote will be for script as it is handy and easy.To call it from anywhere: you need to make small entry in .profile or .login or .cshrc file which is generally hidden and can’t be seen simply.
you need to use (ls -a) to see hidden files.
Objective of this post is to address below questions

Read more ›

Handling Multiple delimiters in a informatica source file

August 20, 2012 6:05 pm5 comments
Flat file source properties

Ever come across a flat file source with multiple delimiters and wondered how these source files can be handled and read accurately. Multi delimiter file data essentially looks as given below; one or more delimiter candidates define the boundaries of a column as stated in my sample data.

order_no|product $ region ~ units sold ~ discount_pct | Sales_amount | discount_candidate

Read more ›

Informatica Joiner Transformation – and its comparison with Lookup Transformation

June 17, 2012 6:19 pm3 comments
Informatica Joiner Transformation – and its comparison with Lookup Transformation

Let’s discuss “Informatica joiner versus lookup transformation”. While discussing this we will even get solutions for below brain storming questions also. Very well known as interview questions. Though i very much believe this is not the right way to take an interview.

Read more ›

Why You Should Learn Informatica Active Passive Transformations !!!

June 2, 2012 12:00 pm0 comments
Why You Should Learn Informatica Active Passive Transformations !!!

Though informatica active passive transformation looks simple but sometime they get very challenging. if someone put it across intelligently. it is very broader and one of the first attribute of informatica transformation. Generally we come across of it at very beginning of our informatica tool training. Before we get into those examples. let’s see a generic definition given in informatica help.

Read more ›