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

Which transformation should we use to normalise the COBOL and relational sources?

830


I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1233


Explain the pipeline partition with real time example?

751


Performance tuning( what you did in performance tuning)

1594


How can informatica be used for an organization?

752






What are the types of schemas we have in data warehouse.

621


What are the data movement modes in informatica?

793


Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

1955


What are the databases that informatica can connect to windows?

677


Which is the t/r that builts only single cache memory?

821


What is flashback table ? Advance thanks

1593


Explain what transformation and how many are there in informatica?

587


How to load data in informatica ?

665


How can a transformation be made reusable?

749


Explain what are the different versions of informatica?

758