Answer Posted / 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 |
Post New Answer View All Answers
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What is the format of informatica objects in a repository?
Separate from an archive server and a powerhouse?
What are the informatica performance improvement tips
Explain what is informatica metadata and where is it stored?
What is the Process to creating lookup transformation in informatica
Explain the difference between mapping parameter and mapping variable?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What are the settings that you use to configure the joiner transformation?
What is a connected transformation?
How many ways are there to create ports?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
According to his methodology what all you need before you build a datawarehouse
What is the need of an ETL tool?
What do mean by local and global repository?