Interested to Buy Any Domain ? << Click Here >> for more details...
What are parallel querys and query hints?
- 1 Answers
- 7996 Views
- I also Faced
- E-Mail Answers
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 |
1)can anyone explain how to use Normalizer transformation for the following scenario Source table | Target Table | Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh Ramesh 68 82 78 | ENG 68 73 81 Himesh 73 87 89 | MAT 82 87 79 Mahesh 81 79 64 | ART 78 89 64 | please explain what should be the normalizer column(s) The GCID column 2)Also please explain the Ni-or-1 rule.
5 Answers FCS, IBM, Satyam, TCS,
wht is full process of Information source to target just like stg to productuon and development
How to Join Tables my Source is having 15 table target is one?
,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
what is bridge tables in informatica
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
how to call lookup qualifer in unconnected look;up
We can achieve better perfomance using sorter before an aggragator. Then what is the significance of 'Sorted Input' check in aggregator ?? Please let me know the difference ??
my source having the records like ram 3 sam 5 tom 8 and i want to load into target like ram record 3 times,sam record 5 times, tom record 8 times
How can you access the remote source into your session?
What is the way to execute pl/sql script using informatica mapping?
Teradata 
