what is parallel querying and what r hints.
Answer / 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 |
Can we have a Mapping without a Source Qualifier?
What is a surrogate key?Why we use it in a mapping?Pl give an example.
How to improve the performance of a session using sorter transformation?
i have source as Column1 101 a 101 b 101 c so i want to load target as column1 ---> 101 abc
What is Datadriven?
What are the performance considerations when working with aggregator transformation?
What is the function of union transformation?
Quickly characterize reusable change?
what is correlated query?
How to enter same record twice in the target table,explain?
how to return multiple columes through through un-connect lookup?
on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records