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 |
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Mention some types of transformation?
Hi , Please help how to achieve the following scenario. I have a source table like this. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU I need the data in the target table like below. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU 4 Rajesh 5th SKU The Last row values we have.. and we have to append this last row in the target table. Thanks and Regards Nataraj V
What is critical mapping?
What is mapplet and a reusable transformation?
waht type of interface is used for testing the data in informatica
Can we have a Mapping without a Source Qualifier?
disable caching in a lookup transformation?
What is source qualifier transformation?
what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?
i have two sources both is oracle database . one is coming from USA database and another one is coming from U.k database .i am using source qualifier transformation to join this.as that time in session level source properties which path i need to give to retrieve that data. thanks bala 09619894486
what is SDLC way of code development?