Interview Questions

Cluster analysis is used to define the object without giving the class label. It analyzes all the data that is present in the data warehouse and compare the cluster with the cluster that is already running. It performs the task of assigning some set of objects into the groups are also known as clusters. It is used to perform the data mining job using the technique like statistical data analysis. It includes all the information and knowledge around many fields like machine learning, pattern recognition, image analysis and bio-informatics. Cluster analysis performs the iterative process of knowledge discovery and includes trials and failures. It is used with the pre-processing and other parameters as a result to achieve the properties that are desired to be used.

Sequence numbers can be generated in Datastage using certain routines. They are

-KeyMgtGetNextVal

-KeyMgtGetNextValConn

Tell us about a time when you missed a deadline.

(or)

Let's discuss a time when you missed a significant deadline.

If you answer something like "You never missed a deadline". Most interviewers will immediately conclude you are not experienced and may also feel you are lying. 

Approach - It is absolutely necessary to accept that you have missed a deadline and give reasons how you resolved and what you learned from it. This will demonstrate your experience.

You could say in one of the first projects earlier in your career you missed an important deadline and made the boss very upset. It was a great learning experience and after doing some introspection, you realized, you could have done better planning, prioritization and communication. Now, you use special tools, processes and methods to address these issues. Now your team, colleagues and management are always up to date so no surprises arise on meeting deadlines. 

Below are few things you may emphasize on in your response...

Effective planning

Procedural Improvements

Better Prioritization

Open communication

Better Status reporting

Answer : s1 and s2 are equals()

Explanation :


SELECT COUNT(*), sex from Employees  WHERE  DOB BETWEEN ‘01/01/1960 ' AND ‘31/12/1975’  GROUP BY sex;

Language attribute contains the javascript versions.

we can always fetch from one database and rewrite to another. Here is a nice solution of it.$db1 = mysql_connect("host","user","pwd")
mysql_select_db("db1", $db1);
$res1 = mysql_query("query",$db1);$db2 = mysql_connect("host","user","pwd")
mysql_select_db("db2", $db2);
$res2 = mysql_query("query",$db2);At this point you can only fetch records from you previous ResultSet, i.e $res1 – But you cannot execute new query in $db1, even if you supply the link as because the link was overwritten by the new db.so at this point the following script will fail
$res3 = mysql_query("query",$db1); //this will failSo how to solve that?

take a look below.
$db1 = mysql_connect("host","user","pwd")
mysql_select_db("db1", $db1);
$res1 = mysql_query("query",$db1);

$db2 = mysql_connect("host","user","pwd", true)
mysql_select_db("db2", $db2);
$res2 = mysql_query("query",$db2);

So mysql_connect has another optional boolean parameter which indicates whether a link will be created or not, as we connect to the
$db2 with this optional parameter set to 'true', so both link will remain live.

Now the following query will execute successfully.
$res3 = mysql_query("query",$db1);

Linked list is the efficient datastructure in tree construction