Tuesday, January 21, 2014

Informatica : initializing debugger...bind (wsaeaddrinuse)address already in use

click--->Tools-->ooptions-->click on Debug tab and below TCP/IP check pick a port number between Min and Max automatically
Min: 5001 Max:32000

Friday, May 24, 2013

eth0 not showing in CENTOS VM

  1. Check whether the eth0 is available
                /sbin/ifconfig -a

            Please execute the aove script, if your result showing eth0 then please proceed to 2.
      2.    dhclient -v eth0
       This forces the interface to get an IP via DHCP

Then please check whether you can ping to outside world.

Also please check the below file.

/etc/sysconfig/network-scripts/ifcfg-eth0 and set


Sunday, April 7, 2013

Extracting Numerical values from a string

1)  Cutting numerals from a string
        sed 's/[^0-9]*//g'
    For example:
                           Hello world my name is 1234abcd
        Output      : 1234

2)  Extracting First number from a string
        sed 's/[^0-9.]*\([0-9.]*\).*/\1/'
     For example: Hello 123 world, my name is 1234abcd
            output    : 123   

Wednesday, June 6, 2012

How to Read File names from a DIR in PERL

#Reading files from the Directory
my $dir = 'C:\Users\philip\Desktop\sample_files';
 opendir(DIR, $dir) or die $!;
 while (my $file = readdir(DIR)) {
        # Use a regular expression to ignore files beginning with a period
        next if ($file =~ m/^\./);
 print "$file\n";

Dumping CSV files to SQL tables.

Select Import and Export data, by using this you can export any type of datas to your tables.

If you are using window authentication while accessing the tables then you should open this tool by the corresponding net user.

C:\Users\philip\Desktop>runas /netonly /user:DOMAIN\USERNAME "C:\Program Files\Microsoft SQL Server\100\DTS\Binn\DTSWizard.exe"
Enter the password for DOMAIN\USERNAME :