Please can the SQL code below be interpreted
IF EXISTS (Select * from #InsightData where (EmailAddress=@xDCPEmailAddress ) )
SET @xTestMatchCriteria = @xMatchCriteria;
SELECT @xCRMCustomerId=CustomerId, @xCRMDcpCustomerId=DcpCustomerId, @xCRMPortalCustomerID=PortalCustomerID,@xCRMDcpID=DcpID, @xCRMCardNumber=CardNumber, @xCRMEmailAddress=EmailAddress, @xCRMfirtLetterFirstName=firtLetterFirstName,
where (EmailAddress=@xDCPEmailAddress )
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
what is the difference between functional dependecy and
when we login sql editor using username and password then it
says this error "could not resolve service name" then what
can we do at client side.( here thing is tnsnames.ora file
is ok till yesterday and worked well, but now it giving error.
First input columns brand, mt, re values are ov, 1,re vg, 2,re wu ,3,re. Second input columns are brand, mt, cx their records are ov,4,vg ,5,cx Wu, 6,cx and third input columns brand, mt, rt values are ov,7,rt vg, 8,rt wu, 9,rt but my output is brand, re, cx,rt values are ov, 1,4,7 vg, 2,5,8 wu, 3,6,9
What is the cache hit ratio, what impact does it have on
performance of an Oracle database and what is involved in
What is supporting issues GL AP and AR?
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.)
what is isolation level at dead lock?
In one interview...interviewer ask me question pleas tell
me sql server architecture..
can any body tell me the sql server architecture with digram
what is port in oracle? how is it related to database
What is a Built_in subprogram ?
role of sql sever 2005 in database rather than any other
what is rcp,if rcp disabled what happen?
I have a parent program and a child program. I want to write
a statement in Exception Block of the parent program so that
when the statement in the exception block is executed, the
control goes to the next statement in the parent block
bypassing the child block.How do i do that?
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??