There is a trigger defined for INSERT operations on a
table, in an OLTP system. The trigger is written to
instantiate a COM object and pass the newly insterted rows
to it for some custom processing. What do you think of this
implementation? Can this be implemented better?
What is a join and explain different types of joins?
78
What are the disadvantages of cursors? How can you avoid
cursors?
314
Can you have a nested transaction?
111
What are triggers? How many triggers you can have on a
table?
122
When installing the datastage7.5x2 edtion iam getting
aproblem i.e the cpu count is 2 but the cpu count in
installation is one . how can i install in my p.c (system
is dual core).
62
There is a trigger defined for INSERT operations on a
table, in an OLTP system. The trigger is written to
instantiate a COM object and pass the newly insterted rows
to it for some custom processing. What do you think of this
implementation? Can this be implemented better?
99
Hi ,
any one can help me on the same,this is regarding the
Informatica Function doc,i want to know how developer is
will develop the mapping. pl forwar the any function
doc .just for my references.
svlc75@yahoo.co.in
1. Using the XML Document below, with the URI “recipe.xml”
define
the following queries in XQuery:
a.) Give the names of all breakfast in the menu.
b.) Select breakfasts that have price lower than $7.00?
<?xml version="1.0"?>
<breakfast_menu>
<food>
<name>Belgian Waffles</name>
<price>$5.95</price>
<description>
two of our famous Belgian Waffles with plenty of real
maple syrup
</description>
<calories>650</calories>
</food>
<food>
<name>Strawberry Belgian Waffles</name>
<price>$7.95</price>
<description>
light Belgian waffles covered with strawberries and
whipped cream
</description>
<calories>900</calories>
</food>
<food>
<name>Berry-Berry Belgian Waffles</name>
<price>$8.95</price>
<description>
light Belgian waffles covered with an assortment of
fresh berries and whipped cream
</description>
<calories>900</calories>
</food>
<food>
<name>French Toast</name>
<price>$4.50</price>
<description>
thick slices made from our homemade sourdough bread
</description>
<calories>600</calories>
</food>
<food>
<name>Homestyle Breakfast</name>
<price>$6.95</price>
<description>
two eggs, bacon or sausage, toast, and our
ever-popular hash browns
</description>
<calories>950</calories>
</food>
</breakfast_menu>
37
Hi
my program is accesing data from two db2 databases.what
is the bind card for this program to genarate plan? how to
specify the two owners and two qualifiers in bind card
What is the difference between a primary index and a
secondary index? What is a duplicate data entry in an index?
Can a primary index contain duplicates?
64
Any sample or model question of punjab national bank for
deputy manger IT
or any sample of PNB.any1 plz do send on
To Refer this Site to Your Friends 
Site Map