how do u tune queries?
Answer / chitti
U CAN TUNE U R QUERIES BY CREATING INDEXES ON COLUMNS,AND
ELIMINATING KEY CONSTRAINTS .AND ALSO GIVE SORTING IN SQL
ITSELF.
| Is This Answer Correct ? | 2 Yes | 4 No |
What is the term PIPELINE in informatica ?
In target table how to display the system time
Hi All can anyone tell me where i will get Informatica training in Mumbai?
If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks
If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?
server hot-ws270 is connect to Repository B. What does it mean?
What is a stored procedure transformation?
HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.
Diffrence between static and dynamic cache
scenario where i can use only concurrent execution of workflow.
supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How
What are the different types of repositories created using informatica?