How do you call a Stored Procedure from JDBC? - The first step is to create a CallableStatement object. As with Statement and PreparedStatement objects, this is done with an open Connection object. A CallableStatement object contains a call to a stored procedure.
CallableStatement cs =
con.prepareCall(”{call

SHOW_SUPPLIERS}”);

ResultSet rs [...]

• 0 Comments

What is source qualifier?
Difference between DSS & OLTP?
Explain grouped cross tab?
Hierarchy of DWH?
How many repositories can we create in Informatica?
What is surrogate key?
What is difference between Mapplet and reusable transformation?
What is aggregate awareness?
Explain reference cursor?
What are parallel querys and query hints?
DWH architecture?
What are cursors?
Advantages of de normalized data?
What is operational data source (ODS)?
What is meta [...]

• 0 Comments

What SAS statements would you code to read an external raw data file to a DATA step?
How do you read in the variables that you need?
Are you familiar with special input delimiters? How are they used?
If reading a variable length file with fixed input, how would you prevent SAS from reading the next record if [...]

• 0 Comments

What is an oracle instance?
What is a view?
What is referential integrity?
Name the data dictionary that stores user-defined constraints?
What is a collection of privileges?
What is a snapshot?
What is a synonym?
What is a cursor?
What is a sequence?
What is a trigger?
What is an exception?
What is a partition of table?
What are pseudo-columns in SQL? Provide examples.
What are the Data [...]

• 0 Comments