What are parallel querys and query hints?
Answer / nagaraju bhatraju
parallel queries to optimize query execution and index
operations for computers that have more than one
microprocessor (CPU). Because SQL Server can perform a
query or index operation in parallel by using several
operating system threads, the operation can be completed
quickly and efficiently.
| Is This Answer Correct ? | 6 Yes | 0 No |
How would you join a node to the already existing domain?
What is junk dimention?
What is dimensional table?
enterprise datawarehouse your project phase by phase explain?
we have 30 wf with 3 batches means 1batch=10 wf 2 batch=10-20 wf 3batch=20-30wf through unix First you have to complete batch ofter second batch have to run how can you do in unix?
i have 2 mapings for this 2 mapings i want use only one lookupt/r how?
How do you implement configuration management in Informatica?
what is rank and dense rank in informatica with any examples and give sql query for this both ranks
Write the advantages of partitioning a session?
what is the incremental agrrigation?
wt is Dynamic lookup Transformation? when we use?how we use?
In which scenario did u used Mapping variable?