What is the difference between operational data stage (ODS) and data warehouse?

Correct Answer: -Daily loading is known as incremental load -When data is selected from source, selected records are loaded between timestamp of last load and the current time -The parameter that are passed to perform are last loaded date and current date -The first parameter is the stored last run date is read through job parameters -The second parameter is the current date

Correct Answer: Sequence numbers can be generated in Datastage using certain routines They are -KeyMgtGetNextVal -KeyMgtGetNextValConn

Correct Answer: Datastage has two components -Client Components ? Designer, Director, Manager and Administrator -Server Components ? Server, Repository and Plug-ins

Correct Answer: - A tool for designing Extraction, Transformation and Loading - An ideal tool for data integration projects system migrations - Importing, extracting and creating metadata are within these jobs - Data stage allows scheduling, monitoring and running the jobs - Allows to administer the development and execution in a single environment

Correct Answer: The primary keys of entity tables are the foreign keys of dimension tables The Primary keys of fact dimensional table are the foreign keys of fact tablels

Correct Answer: Ensuring Profit

Correct Answer: ActiveX DLL: It is an in process server It runs within the application time ActiveX Exe: It is an out of process server MS-Excel is an activex exe when u call the excel from the vb application u can in the task manager an excel exe will run, whereas for dll u can't see like that

Correct Answer: Yes

Correct Answer: Yes, internally PHP will cast everything to the integer type, so numbers 10 and 11 will be compared

Correct Answer: 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, ie $res1 â?? But you cannot execute new query in $db1, even if you supply the link as because the link was overwritten by the new dbso 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);