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 to identify this row for insert and this row for update in dynamic lookup cache
A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )
what is difference between COM & DCOM?
I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.
What is DTM process?
which is better perfomancewise lookup or joiner and why?can anyone give example?
In router source is a boy age 20 I given 3 conditions in router a>20, a<=20, a=20 which one exit first?
Howmany ways yoU can update a relational source defintion and what are they?
What is an Integration service in Informatica?
can we override a native sql query within informatica? Where do we do it?
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...