Towards tech
Others
RIP Shakuntala Devi : Calculating Prodigy
I first encountered with the name Shakuntala Devi when I was in the final year of engineering and I had to appear with many of the Aptitude test of the IT companies. At that time one particular company firmly prepares the test paper out of Shakuntala Devi book. For final year student like me getting into the company was more important. I purchased that and started reading the book and all my fellow friends did the same thing. At many points me and my friends and all the people who came to appear that test even slogged the answers. Many of them got the job (I was failed). But many of my friends were really happy and directly and indirectly thanked the book written by Shakuntala Devi.
Of course I was dis-appointed with the outcome but going home I searched in Google and referred to wiki site. I was thrilled and really inspired by her story. And recently after her demise I was just searching for any of her interview and I found the below YouTube link. I hope everyone likes it. And lastly RIP Shakuntala Devi.
Related Posts:
Informatica B2B Studio Exception while opening
Today while working on Informatica B2B Studio I encountered a exception while opening the application. Basically previously I had Informatica 9.1.0 version installed in my PC but I need to revert it back to version 8.6.2 so for that I installed 8.6.2 parallel to version 9.1.0. Once installed when I tried to open the application I was getting the below exception.
Error Message:
Cannot read the configuration file.
Please make sure C: \ Informatica \ 9.1.0 \ DataTransformation \ CMconfig.xml is a valid configuration file.
First above error doesn’t generally comes when you have two parallel version installed, it can come for various other reason. I should have not installed the two version parallel, anyways below is the solution.
Solution:
Check environment Variable value, should be:
IFConfigLocation4 = C: \ Informatica \ 9.1.0 \ DataTransformation \ CMConfig.xml
Or, Remove.
Once the above problem is resolved I was able to open the B2B studio but was facing other exception when I tried to create the project.
Error Message:
Internal error logged: Could Not Create IFCMFramework.CFramework Control.
Error details can be found in the log file
Solution :
-
Uninstall all the installation of B2B data transformation.
-
Delete all the physical Data Transformation installation from your HDD.
-
Remove the workspace folder i.e. “C: \ Documents and Settings \ <User>\ My Documents \ Informatica \ DataTransformation \”.
-
Remove the CMReports and USerLogs folders at C: \ Documents and Settings \ <User> \ Application Data \ Informatica \ DataTransformation .
-
Restart your PC
-
Re-install the application and hopefully it should work.
Rishi
Related Posts:
Zoozoo Comic series launched by Vodafone India on Facebook
Recently Vodafone India launched a new comic series on Facebook with one of the most successful character Zoozoo. The comic named “The Adventures of Super Zoozoo” is created by Vodafone’s advertising agency OgilvyOne Worldwide and is available on Vodafone Zoozoo’s Facebook page.
“We have seen that our fans constantly demand new Zoozoo material and a comic series was the most natural extension of the Zoozoos. So far, fans only knew Zoozoos through short ads or through content on our Facebook page. These comics are a great way for readers to get to know the Zoozoo world in all its quirky sweetness,” stated Anuradha Aggarwal, vice president, brand communication and insights, Vodafone India.
Related Posts:
SSH connection using Plink in C#
Recently in of our project there was requirement to connect to the Unix machine using SSH and change the file permission. All this has to be done in the Windows Service using C#.
After quite a lot of Google search I got access to the resource which was uploaded by PUTTY guys itself. Whenever if developer wants to connect to the Unix server using the command line then they can use Plink.
Previously we were using TamirSSH and its quite unreliable. After implementing using Plink it become highly reliable and error free.
I am opening the Command Prompt in the separate process and making it hidden and using command prompt I am connecting to the Unix Server and firing the corresponding Unix Command. Its quite easy and fast to implement.
You can read more about Plink here.
Below is my code, hope it will be useful
1: public void EstablishPlinkConnection()
2: {
3: ProcessStartInfo psi = new ProcessStartInfo(@"cmd.exe");
4: psi.RedirectStandardInput = true;
5: psi.RedirectStandardOutput = true;
6: psi.WindowStyle = System.Diagnostics.ProcessWindowStyle.Normal;
7: psi.UseShellExecute = false;
8: psi.CreateNoWindow = false;
9:
10: Process process = Process.Start(psi);
11: string cmdFoPlink = "plink -ssh -pw <pwd> <username>@<unixserver> sh -x < " + "\""+FilePath+"\"";
12: process.StandardInput.WriteLine(cmdFoPlink );
13: process.StandardInput.Close();
14: process.WaitForExit();
15:
16: if (process.HasExited)
17: {
18: process.Close();
19: process.Dispose();
20: }
21: }
In the above code include all the commands in the File and include that path in the above code. Plink will execute all the commands from the file.
For any queries please mail me @ rishi.daftary@gmail.com
Related Posts:
Oracle : LNNVL Function
Recently I got a very weird CR in my project. In my project we are generating dynamic query for update and insert and that to we will generate it from the datatable column name. Now the problem was, for some column the value can be NULL so in the update statement we can’t write as COLUMNNAME= NULL in where statement. Instead it should be IS NULL. Now the problem was, query was generated much before the actual execution(and actual data) and even that particular column can have value other than NULL, so we can’t have two update statment since it was a datatable update. So after exhausive searching i came up with something called as LNNVL function. LNNVL provides a concise way to evaluate a condition when one or both operands of the condition may be NULL. The function can be used only in the WHERE clause of a query. Basically it will even fetch the NULL records in the query. Oracle site is the best resource for this and if not wrong it is available only for oracle 10g and 11g. Go through the site, hopefully it will be useful.
Rishi
