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
Write short notes on manual refreshes.
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.)
fact table and dimension table containg one to many
relationship or many to one relastionship
What is DB Development software?
What is normalization? Explain different levels of
How to replace not in with not exist?
Does QTP Support the Propjects which are running in Dot Net?
As we are starting with new project in Dot net need to use
automation tool?Please advice & let me know what would be
How to generate OIDS
To convert IDMS to DB2, how to deal with IDMS occurs and
Any sample or model question of punjab national bank for
deputy manger IT
or any sample of PNB.any1 plz do send on
How to use timestamp datatypes
explain detail about ftp in datastage?
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.
I have a few records all are same structures data, I want to
store data in multiple targets how