what is parallel querying and what r hints.

Answer Posted / sabyasachi

Parallei Query: To execute a query with the help of muliple
servers.
QueryHints: This are compiler directives to execute any
particular SQL query.This is generally done to override the
default mode in which the compiler is going to execute the
query.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the shared cache and re-cache?

812


Define sessions in informatica etl?

779


Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

1779


What are the types of caches in lookup?

776


Differentiate between reusable transformation and mapplet.

842


What are the transformations that are not supported in mapplet?

778


what is the Default Source Option For Update Strategy Transformation?

970


What is a surrogate key?

806


Performance tuning( what you did in performance tuning)

1710


can anyone explain me about retail domain project in informatica?

7692


What is Session and Batches?

865


waht type of interface is used for testing the data in informatica

2006


in reporting we add some new objects,how we get the count of the newly added objects to the report

1976


Explain what is informatica metadata and where is it stored?

812


What is mapping debugger?

749