A) Which two are benefits of Teradata's support for ANSI
Standard SQL? (Choose two.)
1.data is distributed automatically
2.queries get optimized to better plans
3.submit queries from other database systems
4.can interface with BI tools
B) Which statement is true when comparing the advantages of
third normal form to star schema?
1.Star schema tends to have fewer entities.
2.Star schema requires additional data storage.
3.Third normal form tends to have fewer entities.
4.Third normal form requires additional data storage.
C)Which two sets of functions does the Parsing Engine (PE)
perform? (Select two.)
1.sorting, formatting, and aggregating of the final answer
2.flow control of the data to and from the participating
3.SQL statement interpretation, syntax validation, and
4.dispatching the step execution sequence to the AMP via
D) Which two can be achieved with Teradata Active System
Management (TASM)? (Choose two.)
2.react to hardware failure
3.influence response times
E) Which three mechanisms can be used to ensure security
within the Teradata Database? (Choose three.)
How to customize error conditions.
Write short notes on manual refreshes.
In which table collections errors are stored.
How to generate OIDS
Explain about query and reporting.
How to combine two function together?
What is normalization? Explain different levels of
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
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.
explain detail about ftp in datastage?
How to use timestamp datatypes
1. Using the XML Document below, with the URI “recipe.xml”
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?
two of our famous Belgian Waffles with plenty of real
<name>Strawberry Belgian Waffles</name>
light Belgian waffles covered with strawberries and
<name>Berry-Berry Belgian Waffles</name>
light Belgian waffles covered with an assortment of
fresh berries and whipped cream
thick slices made from our homemade sourdough bread
two eggs, bacon or sausage, toast, and our
ever-popular hash browns
I have a few records all are same structures data, I want to
store data in multiple targets how